Reference no: EM132239401
The ford motor company has a plant located in Flint Michigan that makes four models of cars. These vehicles and there relevant details are given below: Price Raw Materials Fiesta $13,660.00 $12,000.00 Focus $16,775.00 $14,545.00 Escape $23,750.00 $15,987.00 Explorer $31,660.00 $20,546.00 Time for assembly Fiesta 11 seconds Focus 12 seconds Escape 16.36 seconds Explorer 19.1 secondsOverhead $50,000,000.00 Labor $ 40.00 per hour #of workers 1320 Production Plan (monthly) 4067 14065 25589 20770Question 2 The ford motor company has a plant located in Flint Michigan that makes four models of cars. These vehicles and there relevant details are given below: Price Raw Materials Fiesta $13,660.00 $12,000.00 Focus $16,775.00 $14,545.00 Escape $23,750.00 $15,987.00 Explorer $31,660.00 $20,546.00 Time for assembly Fiesta 11 seconds Focus 12 seconds Escape 16.36 seconds Explorer 19.1 seconds Overhead $50,000,000.00 Labor $ 40.00 per hour #of workers 1320 Production Plan (monthly) 4067 14065 25589 20770 Part 1 What is the revenue generated per product by this plant given the production plan above? What is the raw material cost per product given the production plan above? What is the labor cost per product given the production plan above? What is the overhead cost per product given the production plan above? What is the profit per product given the production plan above? What is the unit profit product given the production plan above? Part 2 An economic downturn has transpired and there now needs to be a shift in production. See the new plan below and apply the ABC method to calculating profit. Production Plan (monthly) 20000 14000 5000 4059Research and Development (in %) Purchasing ( in sqft) Marketing ( in %) Human Resource Management (in labor hours) Accounting and Finance (in labor hours) Fiesta 3.00% 100,000 3.00% 25 25 Focus 15.00% 350,000 15.00% 250 350 Escape 40.00% 550,000 26.00% 750 600 Explorer 42.00% 1,000,000 56.00% 975 875 Total Cost per division $20,000,000.00 $15,000,000.00 $9,000,000.00 $1,500,000.00 $4,500,000.00. What is the labor cost per product given the production plan above? What is the overhead cost per product given the production plan above?