Question

In: Operations Management

The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the...

The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the table. Assuming one-time stockout costs for lost sales of

$125125

per unit, inventory carrying costs of

$2525

per unit per month, and zero beginning and ending inventory, evaluate the following plan on an incremental cost basis:Plan B: Vary the workforce to produce the prior month's demand. The firm produced

1 comma 3001,300

units in June. The cost of hiring additional workers is

$3030

per unit produced. The cost of layoffs is

$6060

per unit cut back.

(Enter

all responses as whole numbers.) Note: Both hiring and layoff costs are incurred in the month of the change (i.e., going from production of

1 comma 3001,300

in July to

10001000

in August requires a layoff (and related costs) of

300300

units in August).

Month

Demand

Production

Hire

(Units)

Layoff

(Units)

Ending Inventory

Stockouts

(Units)

1

July

10001000

1,3001,300

00

00

300300

00

2

August

12001200

10001000

00

300300

100100

00

3

September

14001400

12001200

200200

00

00

100100

4

October

18001800

14001400

200200

00

00

400400

5

November

18001800

18001800

400400

00

00

00

6

December

18001800

18001800

00

00

00

00

The total hiring cost =

$24,00024,000.

(Enter your response as a whole number.)The total layoff cost =

$18,00018,000.

(Enter your response as a whole number.)The total inventory carrying cost =

$10,00010,000.

(Enter your response as a whole number.)The total stockout cost =

$62,50062,500.

(Enter your response as a whole number.)The total cost, excluding normal time labor costs, for Plan B =

$114,500114,500.

(Enter your response as a whole number.)

Question is complete. Tap on the red indicators to see incorrect answers.

All parts showing

Similar Question

Solutions

Expert Solution

Please find below responses in images below with formulas


Related Solutions

The S&OP team at Kansas Furniture, has received the following estimates of demand requirements Assuming one-time...
The S&OP team at Kansas Furniture, has received the following estimates of demand requirements Assuming one-time stockout costs for lost sales of $100 per unit, inventory carrying costs of $25 per unit per month, and zero beginning and ending inventory, evaluate these two plans on an incremental cost basis: Plan A: Produce at a steady rate (equal to minimum requirements) of 1,000 units per month and subcontract additional units at a $60 per unit premium cost. Plan B: Vary the...
An economist estimates that a football team faces the below demand schedule for tickets for each...
An economist estimates that a football team faces the below demand schedule for tickets for each home game it plays. The economist estimates that the team’s marginal cost of attendance, and thus for all tickets sold, is $20. Number of Tickets per Game 0 2,000 3,000 4000 5,000 6,000 7000 Price Per Ticket $85 80 75 65 56 48 38 Construct a table showing columns for the firm’s Total Revenue, Marginal Revenue and Marginal Cost. Draw the demand, marginal revenue...
A four-year financial project has estimates of net cash flows shown in the following table: Year...
A four-year financial project has estimates of net cash flows shown in the following table: Year Net Cash Flow 1 $20,000 2 25,000 3 30,000 4 35,000 It will cost $65,000 to implement the project, all of which must be invested at the beginning of the project. After the fourth year, the project will have no residual value. Using the most likely estimates of cash flows, conduct a discounted cash flow calculation assuming a 20 percent hurdle rate with no...
1. Gallatin, Inc., has assembled the estimates shown below relating to a proposed new investment project....
1. Gallatin, Inc., has assembled the estimates shown below relating to a proposed new investment project. The project will last 5 years and requires Gallatin to purchase a machine with a cost of $335,200, a 5-year life and no salvage value. Annual cash sales $ 350,000 Annual out-of-pocket cash expenses $ 250,000 Annual depreciation on equipment $ 67,040 Initial cost of equipment $ 335,200             a. Compute the payback period for the investment b. Compute the investment's approximate IRR c....
1. Gallatin, Inc., has assembled the estimates shown below relating to a proposed new investment project....
1. Gallatin, Inc., has assembled the estimates shown below relating to a proposed new investment project. The project will last 5 years and requires Gallatin to purchase a machine with a cost of $335,200, a 5-year life and no salvage value. Annual cash sales $ 350,000 Annual out-of-pocket cash expenses $ 250,000 Annual depreciation on equipment $ 67,040 Initial cost of equipment $ 335,200 a.         Compute the payback period for the investment b.         Compute the investment’s approximate IRR c.         Compute...
A manager has just received a revised price schedule from a supplier as shown below. What...
A manager has just received a revised price schedule from a supplier as shown below. What order quantity should the manager use in order to minimize total inventory costs? Annual demand is 1,200 units; ordering cost is $8; and holding cost is 20%. Quantity      Unit Price 1 – 39              $14 40 – 59            $13 60 – 89            $12 90 +                  $ 11
Avila Hotel has 300 rooms and charges $120 per room. The hotel estimates that the demand...
Avila Hotel has 300 rooms and charges $120 per room. The hotel estimates that the demand for the rooms follows a uniform distribution between 270 and 330 each day. Reservations may be canceled by 6pm with no penalty. The hotel estimates that 3% of the reservations are canceled by 6pm. Hence, the hotel allows overbooking by 20 room (the hotel allows up to 320 customers to make reservation). When more customers arrive than can be handled (e.g., more than 300...
Fred's Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters....
Fred's Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters. Quarter Demand Previous quarter's output 800 units 1 700 Beginning inventory 0 units 2 900 Stockout cost $100 per unit 3 1200 Inventory holding cost $10 per unit at end of quarter 4 600 Hiring workers $20 per unit Laying off workers $40 per unit Subcontracting cost $200 per unit Unit cost $100 per unit Which of the following production plans is better: Plan...
ABC Manufacturing has the following Aggregate Plan demand requirements and other data for the upcoming four...
ABC Manufacturing has the following Aggregate Plan demand requirements and other data for the upcoming four quarters. Quarter Demand Previous quarter's output 1500 units 1 1300 Beginning inventory 200 units 2 1400 Stockout cost $50 per unit 3 1500 Inventory holding cost $10 per unit at end of quarter 4 1300 Hiring workers $4 per unit Laying off workers $8 per unit Unit cost $30 per unit Overtime $10 extra per unit By utilizing the aggregate planning excel sheet, answer...
Beer Traditionally, Newland is a wine-drinking country. However, recent market research has shown that demand for...
Beer Traditionally, Newland is a wine-drinking country. However, recent market research has shown that demand for beer in Newland is steadily growing. RichBrew Inc. Of Richland, one of the world's largest beer producers, therefore wants to increase its exports of specialty beers, ordinary beer and non-alcoholic beer to Newland. Before its accession to the WTO, Newland limited the importation of beer of any kind to a meagre 50,000 hectolitres per year. This quantitative restriction was put into place in the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT