Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q22 Q23 Bart Incorporated manufactures auto parts. The demand forecast for one of its key products during the next 8 months is provided in the

Q22
image text in transcribed
image text in transcribed
Q23
image text in transcribed
Bart Incorporated manufactures auto parts. The demand forecast for one of its key products during the next 8 months is provided in the table below. An employee can produce an average of 10 units a month during regular time and overtime. The company does not use under- time or vacation time as options. But, the company relies on hiring, layoffs, anticipation inventory, and overtime as potential supply options. Based on a detailed analysis, the company has determined the inputs (work force level and overtime, in terms of number of employees) as indicated in the following table. Each employee on the payroll costs $2000 in regular-time wages per month. Overtime wages are 50% more than regular-time wages. The company can hire and train a new employee for $2000 and lay off one for $1000. Inventory costs $50 per unit on hand at the end of each month. At the beginning of the planning horizon, Bart Incorporated has 80 employees and anticipation inventory of O. Inventory must be entered as number of units. Utilized time, hires, and layoffs must be entered in terms of number of employees. Please refer to the following aggregate planning table. Based on the inputs provided, fill the derived and calculated parts of the aggregate plan (do not touch the "Inputs" section). + 2 3 6 8 Total 800 750 1000 700 1200 800 1250 1000 80 85 85 95 95 95 95 90 10 20 Period Inputs Forecasted Demand Work force level Undertime Overtime Derived Utilized time Inventory Hires Layoffs Calculated Utilized time cost Undertims cost Overtime cost Inventory cost Hiring cost Layoff cost Q20 Q21 Q22 Q23 Q24 Q25 Total Cost 04 O 5 O 10 O 20 O None of the above F 2 3 5 6 8 Total 800 750 1000 700 1200 800 1250 1000 80 85 85 95 95 95 95 90 10 20 Period Inputs Forecasted Demand Work force level Undertime Overtime Derived Utilized time Inventory Hires Layoffs Calculated Utilized time cost Undertime cost Overtime cost Inventory cost Hiring cost Layoff cost Q20 Q21 Q22 Q23 Q24 Q25 Total Cost O 160000 O 170000 O 190000 O 200000 O None of the above Bart Incorporated manufactures auto parts. The demand forecast for one of its key products during the next 8 months is provided in the table below. An employee can produce an average of 10 units a month during regular time and overtime. The company does not use under- time or vacation time as options. But, the company relies on hiring, layoffs, anticipation inventory, and overtime as potential supply options. Based on a detailed analysis, the company has determined the inputs (work force level and overtime, in terms of number of employees) as indicated in the following table. Each employee on the payroll costs $2000 in regular-time wages per month. Overtime wages are 50% more than regular-time wages. The company can hire and train a new employee for $2000 and lay off one for $1000. Inventory costs $50 per unit on hand at the end of each month. At the beginning of the planning horizon, Bart Incorporated has 80 employees and anticipation inventory of O. Inventory must be entered as number of units. Utilized time, hires, and layoffs must be entered in terms of number of employees. Please refer to the following aggregate planning table. Based on the inputs provided, fill the derived and calculated parts of the aggregate plan (do not touch the "Inputs" section). + 2 3 6 8 Total 800 750 1000 700 1200 800 1250 1000 80 85 85 95 95 95 95 90 10 20 Period Inputs Forecasted Demand Work force level Undertime Overtime Derived Utilized time Inventory Hires Layoffs Calculated Utilized time cost Undertims cost Overtime cost Inventory cost Hiring cost Layoff cost Q20 Q21 Q22 Q23 Q24 Q25 Total Cost 04 O 5 O 10 O 20 O None of the above F 2 3 5 6 8 Total 800 750 1000 700 1200 800 1250 1000 80 85 85 95 95 95 95 90 10 20 Period Inputs Forecasted Demand Work force level Undertime Overtime Derived Utilized time Inventory Hires Layoffs Calculated Utilized time cost Undertime cost Overtime cost Inventory cost Hiring cost Layoff cost Q20 Q21 Q22 Q23 Q24 Q25 Total Cost O 160000 O 170000 O 190000 O 200000 O None of the above

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance The Basics

Authors: Erik Banks

3rd Edition

1138919780, 9781138919785

More Books

Students also viewed these Accounting questions

Question

describe several successful positive work interventions.

Answered: 1 week ago

Question

What other blunt questions do you think would be appropriate?

Answered: 1 week ago