Kchis2AF1NThe president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows:JanuaryMay2,100June2,100FebruaryMarchJuly1,700AprilAugust1,400Her operations manager is considering a new plan, which begins in January with 200 units on hand and ends with zero inventory. Stockout cost of lost sales is $125 per unit. Inventory holding cost is$20 per unit per month. Ignore any idle-time costs. The plan is called plan B.Plan B: Produce at a constant rate of 1,400 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $75 per unit. Subcontractingcapacity is limited to 700 units per month. Evaluate this plan by computing the costs for January through August.Calculator Ask my instructorIn order to arrive at the costs, first compute the ending inventory and subcontracting units for each month by filling in the table below (enter your responses as whole numbers).0@2WSF2XHcommand#m3E30F3D$4C900888F4RFde L%5V20FSTG0Period Month Demand ProductionDecemberJanuaryFebruaryMarchAprilMay6June7July8 August123456B1,4001,7001,7001,800MacBook ProMF6YH&71,4001.7001,7001,8002,1002,1001,7001,400N999F7UJ1,4001,4001,4001,4001,4001,4001,4001,400*8DII-MEndingInventory200MKMFM3PBS8M(9DDF9<OIHSubcontractUnits).c0Lcommand4F10P^•.2:;Clear allCF11option{[?+ 11==..1Check answerF12◄}]delete▼1returnshi

Month Demand December - January 1400 February 1700 March 1700 April 1800 May 2100…

Answered: K The president of Hill Enterprises,…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Snip
pls help me Blazerauto inc is considering whether to produce a new line of car. The company estimates that the variable cost for each car to be manufactured and sold is 10000 and fixed cost per year is 720000. The selling price is 25,000 per car. The supplier that provides the seats for the cars has a maximum yearly production capacity of 20,000. What is the Output, decision variable, parameters, and constraints? What is the break even point for blazerauto?
Vartan Information Technologies has a division called Useless Transistors. It is considering an « overhaul » of Useless Transistors’ operations or moving Useless overseas. Inventory management is receiving considerable attention. Vartan collected data for the years 2014, 2015, and a forecast for 2016. This data is provided below. What would be Useless Transistors’ weeks of supply for 2015? Projected 2014 2015 2016 Sales $127,890,000 $148,900,000 $192,340,000 Beginning Inventory $3,897,234 $5,467,983 $6,183,230 Ending Inventory $5,467,983 $6,183,230 $4,654,129 Cost of Goods Sold $16,876,400 $20,376,548 $22,346,786 Group of answer choices
I completed those steps and it is saying my answer is incorrect
Sapphire Aerospace operates 52 weeks per year, and its costof goods sold last year was $6,500,000. The firm carries eightitems in inventory: four raw materials, two work-in-processitems, and two finished goods. Table 12.3 shows last year’saverage inventory levels for these items, along with their unitvalues.a. What is the average aggregate inventory value?b. How many weeks of supply does the firm have?c. What was the inventory turnover last year?
part b
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 $100 per unit, inventory carrying costs of $25 per unit per month, and zero beginning and ending inventory, evaluate the following plan on an incremental cost basis: Plan A: Produce at a steady rate (equal to minimum requirements) of 1,200 units per month and subcontract additional units at a $70 per unit premium cost. Subcontracting capacity is limited to 500 units per month. (Enter all responses as whole numbers). The total cost, excluding normal time labor costs, for Plan A = $ Month Ending Subcontract Demand Production Inventory (Units) 1 July 1200 1,200 0 0 2 August 1300 1,200 0 100 3 September 1200 1,200 0 0 4 October 1700 1,200 0 500 5 November 1650 1,200 0 450 6 December 1400 1,200 0 200 (Enter your response as a whole number.)
Deforrest Marine Motors manufactures engines for the speedboat racing circuit. As part of their annual planning cycle, they forecasted demand for the next four quarters. The number of available days of production and the anticipated demand are given below. Employees Production Rate Production Cost Backorder Cost Overtime Cost Overtime Limit Demand Q1 2,400 6,019,000 They also estimated many of the costs required to conduct operations planning. Some of these key figures are listed below. 30 70 units/employee/quarter Q2 2,200 $1,000/unit $200/unit/quarter $1,500/unit <= 25% of Reg. Production Q3 1,700 Q4 1,800 Hire Cost Fire Cost Subcontracting Cost Subcontracting Limit Inventory Cost Initial Inventory $1,200/employee $800/employee $1,800/unit 400 units maximum $100/unit/quarter 280 units Deforrest Marine Motors wishes to maintain the current number of employees for the entire year to follow a level strategy balanced with inventory and backorders as needed. What is the total cost of this…
VT Company produces lawn movers and leaf blowers. The company must develop an aggregate plan given the forecast for engine demand shown in the table. The department has a regular output capacity of 150 engines per month. Regular output has a cost of RM55 per engine. The beginning inventory is zero engines. Overtime has a cost of RM80 per engine. Month 2 3 4 7 8 Total Forecast 125 135 140 120 125 125 135 135 1,040 Develop an aggregate plan that matches the forecast and compute the total cost of your plan. Regular production can be less than regular capacity. Explain your plan.
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May February 1,500 June 2,200 2,200 March April 1,800 1,700 July August 1,700 1,500 Her operations manager is considering a new plan, which begins in January with 200 units on hand and ends with zero inventory. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan B. Plan B: Produce at a constant rate of 1,400 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $80 per unit. Subcontracting capacity is limited to 800 units per month. Evaluate this plan by computing the costs for January through August. In order to arrive at the costs, first compute the ending inventory and subcontracting units for each month by filling in the table below (enter your responses as whole numbers). Period…
Yu Amy Xia bas developed a specialized airtightvacuum bag to extend the freshness of seafood shipped to restaurants.She has put together the following demand cost data: You decides that the initial inventory of 250 units will incur the$0.20/unit cost from each prior quarter (unlike the situation inmost other companies, where a 0 unit cost is assigned).a) Find the optimal pla n using the transportation method.b) What is the cost of the plan?c) Does any regula r time capacity go unused? If so, how much in which periods?b) What is the extent of backordering in units and dollars?
9) APP Transportation Summary Table Given the following summary table from a Transportation Method Production Plan: What is the value of X (inventory at the end of the 3rd quarter)? Group of answer choices a) 8,100 b) 7,300 c) 1,900 d) 15,400 e) 0

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS