A small company produces recreational vehicles. The(in units):Mar Apr May Jun Jul Aug Sep50TotalMonth359Forecast5560 60 405044Use the following information:Regular labour cost$240 per unitOvertime labour cost$360 per unitRegular capacity40 units per month, using5 workersOvertime capacity8 units per monthHolding cost$30 per unit per monthBack-order cost$100 per unit per monthBeginning inventoryDesired ending inventory 0Hiring cost$2,000 per workerDevelop the minimum cost production plan and computeits total cost.

Given values are as follows: Regular capacity = 40 units/month Regular labour cost = 240/unit…

Answered: $2,000 per worker Develop the minimum…

Business

Operations Management

$2,000 per worker Develop the minimum cost production plan and compute its total cost.

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

Assume you are the manager of a shop that assembles power tools. You have just received an order for 50 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Iten Lead Time (weeks) On Hand Sav 2 A B C 4202 D E 15 10 E(3) & E(2) LT=1 week Lot size: Lot-for-Lot Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release 5 65 20 10 30 Components A(2), B(1), C(4) E(3), D(1) Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.) Beg: Inv D(2), (3) E(2), D(2) 2 9
a) b) C) d) Suppose we wish to set up a production plan for the JC Company for the next six months. We are given the following information: Number of working days Demand forecast Beginning Inventory Workforce size Labor hours required per unit: Safety stock: Straight-time cost per hour (first 8 hrs) Overtime cost per hour Inventory holding cost (unit/month) Jan 22 2000 157,000 156,000 155,000 158,000 Feb March April 19 21 21 1800 1200 1100 0 30 5 25% of the demand forecast $3,00 $5,00 $1,00 May 22 1100 June 20 1400 JC Company is planning to produce using a constant workforce (given above) on regular time and they will use overtime to meet additional output requirements. Calculate the total cost of this plan.
Calculate customer life time value for the data below. (Show Work) Purchase Occasion Transition Probability Average Basket Size 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ΝΑ 55% 75% 78% 83% 81% 81% 86% 82% 85% 90% 93% 85% 89% 85% 91% 97% 97% 96% 85% 83% 89% 82% 79% 82% 89% 88% 86% 67% 75% $46.71 $56.71 $57.93 $56.87 $58.26 $66.90 $63.62 $70.27 $63.03 $62.60 $71.81 $76.76 $78.14 $65.65 $74.84 $81.11 $72.08 $87.30 $71.94 $75.44 $70.35 $72.86 $66.68 $79.90 $93.91 $61.08 $94.16 $100.40 $77.89 $99.70
Supply/Demand Info Predicted Sales Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees Cost variables are as follows: Cost Variables Labor cost/hour Overtime cost/ton Subcontracting costiton Holding cost ton/month Hiring cost employee Firing cost/employee Beginning Apr May 4,200 531 $20 $32 $25 $10 $3.700 $4.000 Jun 51,500 50.300 61,600 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/ton Regular production tons/employee/month Max regular production (tons/month) Max overtime production (tons/month) Max subcontractor production (tons/month) 3 100 56,700 3,700 6,000 Jul Aug Sep 45,400 56.600 62,800 Given the above information (and don't overlook beginning number of employees and inventory levels in the first table), create a LEVEL production plan with only the use of regular production and no inventory left over at the end of the six-month period. What is the regular…
4. (Ch10) A retailer experiences a seasonal demand pattern for its services. Labor requirements over a typical six-month period follow. Period Requirement 1 12 2 10 Costs associated with operations are as follows: Wages = $1,500 per worker per month Hiring cost = $1,500 per worker Layoff cost = $1,500 per worker 3 12 4 8 5 9 6 8 The current workforce level is 11 workers. Use the spreadsheet approach and the preceding data to answer the following questions. a. What is the total cost of the staffing plan, including the cost of regular wages, hiring, and layoffs using a chase strategy with hiring and layoffs, but no overtime? b. What is the total cost of the staffing plan, using a level strategy in which no overtime is allowed, and the undertime paid for? c. Suppose that overtime is allowed up to 25% of the regular-time capacity, and that overtime wages are 150% of the regular-time rate. What is the total cost of the level strategy with overtime and undertime that also minimizes…
c. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). MONTH PRODUCTION DAYS DEMAND FORECAST DEMAND PER DAY JAN 2022 16 150 ? FEB 2022 16 150 ? MAR 2022 23 250 ? APR 2022 21 250 ? MAY 2022 22 400 ? JUN 2022 22 500 ? JUL 2022 21 600 ? AUG 2022 20 750 ? SEP 2022 20 450 ? OCT 2022 20 250 ? NOV 2022 16 150 ? DEC 2022 16 150 ? TOTAL ? ? d. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number). e. Prepare a graph showing the monthly forecasts and average daily forecast (in units per day) for MPQ Limited.
Model A B C Labor Hours Used Hours Available Tubing Pumps A B C Blue Ridge Hot Tubs Total Profit Pumps Tubing Number to Assembl Require Require Make y hours d Resources Used Demand Min 15 12 10 322 Max 130 Available 650 88 30 40 45 d 112 A B C 11 10 12 Profit/Unit $ 96.00 $ 75.00 $ 116.00 Blue Ridge Hot Tubs is a local company that just received a donation of tubes and pumps used for hot tubs. The company wants to know how many of each model they should make in order to maximize their profits. They need to stay within the amount of available hours, can't make more than what they have the resources for, and want to stay within the minimum and maximum demand.
Month# Jan Feb Mar Apr May June Forecast# 1800 1500 1100 1500 2100 1600 Name Labor hours per unit (hr/unit) Initial number of workers Safety Stock (units) Working hours in a day(hr/day) Beginning inventory(units) Value 5 30 0 9 450 Month# Jan Feb Mar Apr May June Working Days available 21 21 21 21 21 19 The tables present forecasts, production, and cost information for aggregate planning. Using a level strategy with backorders to produce at average demand, now many workers are required each month? (Round up the calculated number of workers to the nearest whole number, and round the production rate to the nearest whole number
Last Year Sales $208,000 $221,000 Cost of goods sold 106,000 116,000 Gross margin 102,000 105,000 Other expenses 49,000 49,000 Net income 53,000 56,000 Finished goods inventory 2,700 5,000 Work-in-process inventory 11,000 8,000 Raw material inventory 5,500 7,000 Total inventory (average for year) 19,200 20,000 Other current assets 93,000 109,000 Other assets 210,000 249,000 Total assets 322,200 378,000 ^THIS YEAR The plant manager, Murat Kristal, at York Technologies makes Aircraft Navigation Systems. He expects you, as the new OM analyst, to provide some insight for performance of the plant. High on his list is an understanding of his inventory…
Last Year Sales $208,000 $221,000 Cost of goods sold 106,000 116,000 Gross margin 102,000 105,000 Other expenses 49,000 49,000 Net income 53,000 56,000 Finished goods inventory 2,700 5,000 Work-in-process inventory 11,000 8,000 Raw material inventory 5,500 7,000 Total inventory (average for year) 19,200 20,000 Other current assets 93,000 109,000 Other assets 210,000 249,000 Total assets 322,200 378,000 ^THIS YEAR The plant manager, Murat Kristal, at York Technologies makes Aircraft Navigation Systems. He expects you, as the new OM analyst, to provide some insight for performance of the plant. High on his list is an understanding of his inventory…
A steel workshop of PT Mental Baja produces leaf springs for cars. theyhave a demand forecast for the next 6 months as anext:i. January 446 units (production time 20 days)ii. February 600 units (production time 18 days)iii. March 700 units (production time 20 days)iv. April 900 units (production time 20 days)v. May 650 units (production time 20 days)vi. June 550 units (production time 20 days) The following are some important information to be the basis for doingcalculation of production costs as follows:i. Inventory cost $4 per unitii. Subcontractor fee $15 per unitiii. Workers cost $10 per hour or $80 per dayiv. Production time per unit 1.6 hours Tasks and questionsa. Assuming that the number of units that can be produced is 35 units per dayand 1 person can make 7 units, make an estimated cost by usingConstant Workforce approach. b. Assuming that internal processing is carried out usingcapacitors of daily production are the lowest for 6 months and constant,calculate estimated…
Costs Holding cost $8/ refrigerator/ month Subcontracting $80/ refrigerator Regular-time labor $12/ hour Overtime labor $18/ hour for hours above 8 hours/ worker/ day Hiring cost $40/ refrigerator Layoff cost $80/ refrigerator Stockout cost none Other Data Current workforce (December) 8 people Labor hours/ refrigerator 4 hours Workdays/ month 20 days Beginning inventory 250 refrigerators Units demanded in December 320 refrigerators Month Demand Forecast January 400 February 500 March 550 April 700 May 800 June 700