Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need explanation of every step 8. Begin by creating defined names for the following cell ranges. A7:37, A9:39, A13:B15, A19:319, A21:B21 and A26:B28. You will
need explanation of every step
8. Begin by creating defined names for the following cell ranges. A7:37, A9:39, A13:B15, A19:319, A21:B21 and A26:B28. You will use these in the forecasting scenarios in the follow steps. (2 marks) 9. Using Scenario Manager, create these What-if scenarios (use the defined names you created) (4 marks): Scenarios Changing Cells Original Forecast High Sales Low Sales Summer Promotion Mark up .52 .57 .50 .45 Units Sold 500,000 575,000 450,000 600,000 Salaries and Expenses 880,000 1,080,000 880,000 1,080,000 Stocking and Storage 345,350 345,350 245,350 245,350 Miscellaneous 230,000 430,000 120,000 220,000 Direct Material Costs 1,450,700 1,650,700 1,050,700 1,575,700 Manufacturing Overhead 545,350 545,350 345,350 545,350 10. Create a Scenario Summary Report of the four scenarios that you'd like to present to your manager, displaying their impact on total revenue, total expenses, net income, cost per unit and selling price per unit (Result Cells). Move the worksheet to the right of the Price Analysis worksheet. (2 marks) 5969 Fogy Sy ting - D M N now And at Variable Producto US Serie Voruto STY yo 5 Stocking and Store 18 DSPC DOO order Produced ANTS DYMAI BUS OF and Mo WOLTERO DESERT Price 8. Begin by creating defined names for the following cell ranges. A7:37, A9:39, A13:B15, A19:319, A21:B21 and A26:B28. You will use these in the forecasting scenarios in the follow steps. (2 marks) 9. Using Scenario Manager, create these What-if scenarios (use the defined names you created) (4 marks): Scenarios Changing Cells Original Forecast High Sales Low Sales Summer Promotion Mark up .52 .57 .50 .45 Units Sold 500,000 575,000 450,000 600,000 Salaries and Expenses 880,000 1,080,000 880,000 1,080,000 Stocking and Storage 345,350 345,350 245,350 245,350 Miscellaneous 230,000 430,000 120,000 220,000 Direct Material Costs 1,450,700 1,650,700 1,050,700 1,575,700 Manufacturing Overhead 545,350 545,350 345,350 545,350 10. Create a Scenario Summary Report of the four scenarios that you'd like to present to your manager, displaying their impact on total revenue, total expenses, net income, cost per unit and selling price per unit (Result Cells). Move the worksheet to the right of the Price Analysis worksheet. (2 marks) 5969 Fogy Sy ting - D M N now And at Variable Producto US Serie Voruto STY yo 5 Stocking and Store 18 DSPC DOO order Produced ANTS DYMAI BUS OF and Mo WOLTERO DESERT Price
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started