New Perspectives Excel 365/2021 | Modules 5-8: SAM Capstone Project 1a | NP_EX365_2021_CS5-8a

For Help Contact Me on
WhatsApp Number : [phone]
Hire Me For Complete Course
#NewPerspectivesExcel365/2021
#Modules5-8
#SAMCapstoneProject1a
#Modules5-8SAMCapstoneProject1a
#NP_EX365_2021_CS5-8a_FirstLastName_1.xlsx
#NP_EX365_2021_CS5-8a
#NP_EX365_2021_CS5-8a_FirstLastName
#NP_EX365_2021_CS5-8a_FirstLastName_1
NP_EX365_2021_CS5-8a_FirstLastName_2.xlsx
#Support_EX365_2021_CS5-8a_2023.xlsx
#Support_EX365_2021_CS5-8a_Management.docx
#Modules5-8
#NewPerspectivesExcel2019
20. Go to the Suppliers worksheet, where Benicio wants to determine whether subcontracting could reduce the cost of the new virtual assistant product.
Run Solver to solve this problem as follows:
a. Set the objective as minimizing (Min) the total cost (cell E10).
b. Use the units produced values (range B5:D5) as the changing variable cells.
c. Adjust the number of units produced by each supplier using the following constraints:
· Set the total number of virtual assistants produced (cell E5) as greater than or equal to 11,000, DIG Technology's minimum production goal.
· Set the total cost (cell E10) to be less than or equal to 925,000, the maximum total cost DIG Technology wants to spend.
· Set the total number of virtual assistants produced by a single supplier (range B5:D5) to be less than or equal to 4000 to balance the production among the suppliers.
d. Run Solver, keep the solution, and then return to the Solver Parameters dialog box. Save the model in the range A14:A21.
22. Go to the Product Mix worksheet, which calculates the profit from each model of portable speaker. Benicio wants to compare three scenarios: one with the current prices and costs, another with the prices raised $10.00, and a third that reduces the variable costs per unit by $5.00. He has already created the first two scenarios and defined names for cells and ranges.
Create a third scenario as follows:
a. In the Scenario Manager, add a scenario using Reduced Costs as the name.
b. Accept the same changing cells (nonadjacent ranges B6:F6 and B11:F12) as the other two scenarios.
c. Reduce each variable cost per unit value (Mini1_Variable_Cost, Mini2_Variable_Cost, VoiceXP_Variable_Cost, VoiceXP10_Variable_Cost, and Waterproof_Variable_Cost) by $5.00.
d. Create a Scenario Summary report that summarizes the effect of the three scenarios. Use the profit per unit sold (range B17:F17) as the result cells.
23. Return to the Product Mix worksheet. Benicio wants to provide a visual way to compare the scenarios.
Use the Scenario Manager as follows to create a PivotTable that compares the profit per unit in each scenario as follows:
a. Create a Scenario PivotTable report using the profit per unit sold (range B17:F17) as the result cells.
b. Remove the Filter field from the PivotTable.
c. Change the number format of the value fields to Currency with 2 decimal places and the $ symbol.
18. Go to the Sales Projections worksheet, which provides a profit analysis of a new virtual assistant product DIG Technology is planning to develop. Benicio wants to make sure the total expense per unit sold calculation in cell B17 does not produce a divide by zero error.
Modify the formula in cell B17 as follows:
a. Add the IFERROR function to the formula in cell B17.
b. Use "Divide total expenses by units manufactured" as the message to display in case of an error.
1. Benicio Cortez is a financial consultant with NewSight Consulting in Denver, Colorado. He is working with DIG Technology, a company that sells five models of portable speakers to consumers in North America. In an Excel workbook, Benicio is analyzing the performance of each speaker model and projecting sales for a new product. He asks for your help in completing the analysis.
Go to the U.S. worksheet. Benicio has received annual sales worksheets from the main offices in the three countries where DIG Technology sells products: the United States, Canada, and Mexico. The worksheets for the countries have a similar structure. Complete the worksheets as follows:
a. Group the U.S., Canada, and Mexico worksheets.
b. In cell F5, insert a formula using the SUM function that totals the Mini sales amounts for Quarters 1-4 (range B5:E5).
c. Fill the range F6:F7 with the formula in cell F5 to display the totals for the other types of portable speakers.
d. Ungroup the worksheets and then check to confirm that all three worksheets reflect the changes you made in this step.
2. Go to the All Locations worksheet, where Benicio wants to summarize the quarterly and annual totals from the three locations for each type of product.
Consolidate the sales data from the three locations as follows:
a. In cell B5, enter a formula using the SUM function and 3-D references that totals the Mini sales values (cell B5) in Quarter 1 from the U.S., Canada, and Mexico worksheets.
b. Fill the range C5:E5 with the formula in cell B5 to total the Mini

[@jakestephano3145]

Thank you so much for your work sir, I dont know why people are complaining when this is literally out here for free. Please keep up the good work, how can I support you

[@StewartLee1]

You are very welcome

[@Sohichipvp]

Can you make the whatsap number bar bigger cause I cant read it. Not like its in the way or anything.

[@StewartLee1]

WhatsApp Number : [phone] Contact here for help

[@beesmith500]

@@StewartLee1 haha he was being sarcastic because its clearly huge and in the way XD

[@paolorduy8649]

How much it cost the complete project?

[@StewartLee1]

Contact on Whatsapp

[@dmachine123]

Whatsapp number blocking everything

[@StewartLee1]

Want Complete Solution Contact on Whatsapp

[@dmachine123]

@@StewartLee1 No thanks I've passed the entire class for free. by using better resources online

[@itunuevelyn8123]

@@dmachine123pls I need help, what resources do you use

[@paolorduy8649]

@@dmachine123 Did you find all 20 points?