a)b)C)d)Suppose we wish to set up a production plan for the JC Company for the next six months. We are giventhe following information:Number of working daysDemand forecastBeginning InventoryWorkforce sizeLabor hours required per unit:Safety stock:Straight-time cost per hour (first 8 hrs)Overtime cost per hourInventory holding cost (unit/month)Jan222000157,000156,000155,000158,000Feb March April192121180012001100030525% of the demand forecast$3,00$5,00$1,00May221100June201400JC Company is planning to produce using a constant workforce (given above) on regular time and theywill use overtime to meet additional output requirements. Calculate the total cost of this plan.

EOQ or economic order quantity is a business production model that lets an organization know how…

Answered: O Suppose we wish to set up a…

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

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…
1. Inventory management for a tyre company? 2. Process management for a tyre company?
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.
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
at is the inventory turnover for last year? is at is is oved More Info Sales Cost of goods sold Gross margin Other expenses Net income Finished goods inventory Work-in-process inventory Raw material inventory Total inventory (average for year) Other current assets Other assets Total assets LAST YEAR $244,000 118,000 126,000 Done 51,000 75,000 0 2,000 9,500 4,000 15,500 90,000. 200,000 305,500 . THIS YEAR $257,000 130,000 127,000 51,000 76,000 4,500 12,000 5,500 22,000 109,000 244,000 375,000 - X
a) b) c) Month January February March Forecast 120 135 140 April 120 May 125 June 125 July 140 August 135 Regular Output Overtime Output Inventory holding cost Backorder cost Hiring Cost Develop a Level Output Plan and identify the total short units in each period and overall in production cycle Develop Chase Output Plan(s) to address the shortage identified in the Level Output Plan. Recommend the most cost-effective plan Capacity Units per $ per Month Unit 500 130 Unlimited 750 50 250 $ per Worker 3000
Fat(g) Item cost($) $0.25 $0.15 $0.10 $0.09 $0.03 $0.04 $0.02 $0.04 Item Sodium(mg) Calories Beef Ratty.m 50 17 220 260 330 310 Bun Cheese 70 Onions 1 10 Pickles 260 5 wer Lettuce 3 4 Ketchup 160 20 Tomato 3 As the owner of a fastfoad restaurant with declining sales, your customers are looking for something new and exciting on the menu. Your market research indicates that they want a burger that is loaded with everything as long as it meets certain health requirements. Money is no object to them. The ingredient list in the table shows what is available to include on the burger. You must include at least one of each item and no more than five of each item. You must use whole items (for example, no half servings of cheese). The final burger must contain less than 3000 mg of sodium, less than 150 grams of fat, and less than 3000 calories. To maintain certain taste quality standards you'll need to keep the servings of ketchup and lettuce the same. Also, you'll need to keep the servings of…
10. Mention and describe what each of the 4 types of approaches to demand analysis discussed in class consists of.
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
A small company produces recreational vehicles. The (in units): Mar Apr May Jun Jul Aug Sep 50 Total Month 359 Forecast 55 60 60 40 50 44 Use the following information: Regular labour cost $240 per unit Overtime labour cost $360 per unit Regular capacity 40 units per month, using 5 workers Overtime capacity 8 units per month Holding cost $30 per unit per month Back-order cost $100 per unit per month Beginning inventory Desired ending inventory 0 Hiring cost $2,000 per worker Develop the minimum cost production plan and compute its total cost.
Table 1. Demand of Hairdryer from January to July [Jadual 1. Permintaan Pengering Rambut dari Januari 2021 hingga Julai 2021] Month Demand January February 2800 2870 March 2968 April Мay 3000 3100 Jun 3150 July 3400 a) Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.[hitung ramalan permintaan masa depan untuk bulan Mei, Jun, Julai dan Ogos dengan menggunakan purata bergerak sederhana 3 bulan.] *
Case Study 4: Inventory Management. I) A Furniture manufacturing company uses 1200 units of an item annually and the cost price is $250 per unit. The ordering costs are $600 per order and holding costs are $4.00 per item per annum. Required: Calculate the economic order quantity. Determine the number of orders per annum. Determine the annual stock holding cost. Determine the annual ordering cost.

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