The project is already done ;however, it needs to be updated according to the reflection! and add more explanation with excel updates to what is done so far.
Develop a 2018 budget for Ace Manufacturing Company. Deliver the budget in spreadsheet format. Please include justifications for your budgetary decisions. The justifications should be written somewhere on the spreadsheet. Below is a very rough outline of the company. Use this as the basis for your assumptions about the company and the resulting 2018 budget. You may add detail as you require to complete the budget. For example yearly sales, unit sales, sales mix, employee salaries, costs of the land and building to maintain, product development costs, testing costs, costs to suppliers, shipping and freight costs for incoming material and outgoing products.
Ace develops and manufactures garden carts for the home user. Ace has 3 products in production and one in development. Ace development, manufacturing and administration is all located in one building that is 40,000 sq. ft. in size.
Product A has 80% material cost and 20% labor and overhead. Product B is 75-25 and Product C 70-30. Ace Mfg. sells to Ace Hardware Stores nationwide and sells directly to consumers by way of being an Amazon supplier.
Ace employs 10 people total. President / VP of Operations, administrative assistant / office manager, VP Finance & Controller, 1 R&D engineer, 1 manufacturing engineer, 2 production employees, 1 purchasing / material handling employee, 1 technical marketing / customer support and 2 salesman.
Product D is being developed in the lab with an introduction expected in June 2018. January through June consumes material for prototypes, project material for analysis and testing resources.
Attached example but you can’t copy or manipulate it. Just picturing the way along with Word File description of how the solution should be approached and explanatory for each part.Thank you