Excel File Frozen Xlsx Frozen Inc Requested Its Analytics Team To Analyze And Create A Spreadsheet Model To Decide Whe 1 (59.08 KiB) Viewed 38 times
Excel File Frozen Xlsx Frozen Inc Requested Its Analytics Team To Analyze And Create A Spreadsheet Model To Decide Whe 2 (26.75 KiB) Viewed 38 times
EXCEL FILE: Frozen.xlsx Frozen Inc. requested its analytics team to analyze and create a spreadsheet model to decide whether it should manufacture its latest type 'z' sleigh model or outsource its production. The team decided to use Excel one way data table for this exercise. The different components are given below. (An Excel template is provided above) [Spreadsheet Modeling] Fixed Cost = $25,000 Material Cost per Unit = $2.15 Labor Cost per Unit = $2.00 Outsourcing Cost per Unit = $4.50 The current production is 30,000 units Instructions: 1. Download the spreadsheet template for Frozen.xlsx. Fill in the parts in yellow. 2. Complete the parameters (2 pts). 3. Compute total cost to produce (1 pts). 4. Compute total cost to outsource (1 pts). 5. Compute savings due to outsourcing (2 pts). 6. Complete the one way table to show the different values of savings from outsourcing (4 pts). 7. Upload your spreadsheet to this canvas question.
100% Viow Zoom Insert Table Chart Text Shape Media Com Sheet1 Parameters Fixed Cost Material Cost per unit Labor Cost per unit Outsourcing Cost per unit Model Quantity 30000 Total cost to produce Quantity 0 5000 10000 15000 20000 25000 30000 35000 40000 45000 50000 55000 60000 65000 70000 25000 80000 85000 90000 Total cost to outsource Savines due to outsource
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!