This is a major project so please show all formulas/work on Excel. Thank you so much!
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | ||||||
Wheels | in Buy | |||||
Make | Buy | Increase/(Decrease) | ||||
Purchase cost | 40,000*$7.31 | $ 292,400 | $ 292,400 | |||
Direct material | $ 140,500 | $ (140,500) | ||||
Direct labor | $ 94,500 | $ (94,500) | ||||
Variable overhead | $ 21,000 | $ (21,000) | ||||
Logo Cost | 40,000*$0.50 | $ 20,000 | $ 20,000 | |||
Fixed overhead | $62,800*25% | $ 62,800 | $ 15,700 | $ (47,100) | ||
Decrease in cost in BUY | $ 9,300 | |||||
Seats | in Buy | |||||
Make | Buy | Increase/(Decrease) | ||||
Purchase cost | 20,000*$8.25 | $ 165,000 | $ 165,000 | |||
Direct material | $ 52,500 | $ (52,500) | ||||
Direct labor | $ 73,500 | $ (73,500) | ||||
Variable overhead | $ 14,000 | $ (14,000) | ||||
Logo Cost | 20,000*$0.50 | $ 10,000 | $ 10,000 | |||
Fixed overhead | $39,600*25% | $ 39,600 | $ 9,900 | $ (29,700) | ||
Decrease in cost in BUY | $ 5,300 | |||||
Calipers | in Buy | |||||
Make | Buy | Increase/(Decrease) | ||||
Purchase cost | 80,000*$2.42 | $ 193,600 | $ 193,600 | |||
Direct material | $ 91,000 | $ (91,000) | ||||
Direct labor | $ 41,000 | $ (41,000) | ||||
Variable overhead | $ 16,000 | $ (16,000) | ||||
Fixed overhead | $29,000*25% | $ 29,000 | $ 7,250 | $ (21,750) | ||
Increase in cost in BUY | $ 23,850 | |||||
Seats and Calipers | in Buy | |||||
Make | Buy | Increase/(Decrease) | ||||
Purchase cost | $ 358,600 | $ 358,600 | ||||
Direct material | $ 143,500 | $ (143,500) | ||||
Direct labor | $ 114,500 | $ (114,500) | ||||
Variable overhead | $ 30,000 | $ (30,000) | ||||
Logo Cost | $ 10,000 | $ 10,000 | ||||
Increase in Net Income | $ (20,000) | $ (20,000) | ||||
Increase in cost in BUY | $ 60,600 |
This is a major project so please show all formulas/work on Excel. Thank you so much!...
You are a financial manager for Zoom Corp., which manufactures bicycles. In the most recent fiscal year, Zoom manufactured and sold 20,000 bicycles. Wheels, seats, and brake calipers are three components of the bicycles currently manufactured by Zoom. Three different vendors have proposed to provide those components to Zoom, and quoted prices (including shipping) for their delivery. Your task is to determine which, if any, of these proposals should be accepted. Prepare a make vs. buy incremental analysis for each...
Could I get this with the formulas as well? Instructions Enter your name and Access ID 'aa1234' format) in the cells above. The data required for this case will not appear until you do so. >> You are a financial manager for Zoom Corp., which manufactures bicycles. In the most recent fiscal year, > Zoom manufactured and sold 20,000 bicycles. Wheels, seats, and brake calipers are three components of the bicycles currently manufactured by Zoom. Three different vendors have proposed...
You are a financial manager for Zoom Corp., which manufactures bicycles. In the most recent fiscal year, Zoom manufactured and sold 20,000 bicycles. Wheels, seats, and brake calipers are three components of the bicycles currently manufactured by Zoom. Three different vendors have proposed to provide those components to Zoom, and quoted prices (including shipping) for their delivery. Your task is to determine which, if any, of these proposals should be accepted. Prepare a make vs. buy incremental analysis for each...
You are a financial manager for Zoom Corp., which manufactures bicycles. In the most recent fiscal year, Zoom manufactured and sold 20,000 bicycles. Wheels, seats, and brake calipers are three components of the bicycles currently manufactured by Zoom. Three different vendors have proposed to provide those components to Zoom, and quoted prices (including shipping) for their delivery. Your task is to determine which, if any, of these proposals should be accepted. Prepare a make vs. buy incremental analysis for each...
10 >> SIM You are a financial manager for Zoom Corp., which manufactures bicycles. In the most recent fiscal year, Zoom manufactured and sold 20,000 bicycles. Wheels, seats, and brake calipers are three components of the bicycles currently manufactured by Zoom. Three different vendors have proposed to provide those components to Zoom, and quoted prices (including shipping) for their delivery. Your task is to determine which, if any, of these proposals should be accepted. Prepare a make vs. buy incremental...
Case1: Incremental Analysis: you are a financial manager for Zoom Corp., which manufactures bicycles. In the most recent fiscal year, 8 >> 10 >> 11 12 13 14 7 Instructions Enter your name and Access ID ('aa1234' format) in the cells above. The data required for this case 9 will not appear until you do so. You are a financial manager for Zoom Corp., which manufactures bicycles. In the most recent fiscal year, Zoom manufactured and sold 20,000 bicycles. Wheels,...
Prepare a make vs. buy incremental analysis for each possible course of action in an Excel worksheet. Your grade will be based on the correctness of your answers, as well as the use of Excel. That is, where possible, you should use formulas to get your answers, rather than keyed-in values. See your instructor for help with Excel basics if you need it. Below is cost data for Zoom's production of wheels, seats, and calipers. Outside suppliers have offered to...
What is the depreciation for the following years, please include the excel formulas. Thank You The office space Janelle plans to rent is unfurnished. She plans to purchase $15,000 worth of furniture and fixtures at the beginning of Year 1. The furniture and fixtures will have a useful life of 15 years. Janelle will also need to buy some computers and other office equipment that she will purchase for $10,000 also at the beginning of Year 1. The office equipment...
please show work. Thank you 3. You need to work on the mini-projects in Excel. Your final mini-project report should be well- organized and typed in a Word file. Are required to submit both your Word report and Excel files to the instructor using the mini-project submission tool in Blackboard. The style and organization of the project accounts for 10 points. 4. You are required to work on the work independently. The due date for the project is 11:59pm on...
also include copanies decision Positive rating awarded upon completion thank you 0 Data Table Direct materials ........................... $ Direct labor Variable manufacturing overhead .......... 18,000 3,200 2,340 6,700 30,240 Fixed manufacturing overhead.. Total manufacturing costs Cost per pair ($30,240 / 1,890) $ 16.00 Print Done X-Perience manufactures snowboards. Its cost of making 1,890 bindings is as follows (Click the icon to view the costs.) Suppose an outside supplier will sell bindings to X-Perience for $16 each. X-Perience will pay $1.00...