Wormwood, Ltd., produces a variety of furniture products. The planning committee wants to prepare an aggregate plan for the next six months using the following information.Month1 2 3 4 5 6Demand 160 150 160 180 170 140CapacityRegular 150 150 150 150 160 160Overtime 10 10 0 10 10 10Cost Per UnitRegular time $50Overtime 75Subcontract 80Inventory holding, per month 4Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero.Develop a plan that minimizes total cost. No back orders are allowed. Regular capacity = Regularproduction.

Wormwood, Ltd., produces a variety of furniture products. The planning committee wants to prepare an aggregate plan for the next six months using the following information.Month1 2 3 4 5 6Demand 160 150 160 180 170 140CapacityRegular 150 150 150 150 160 160Overtime 10 10 0 10 10 10Cost Per UnitRegular time $50Overtime 75Subcontract 80Inventory holding, per month 4Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero.Develop a plan that minimizes total cost. No back orders are allowed. Regular capacity = Regularproduction.

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter19: Pricing Concepts

Section: Chapter Questions

Problem 6DRQ

See similar textbooks

Similar questions

7. Planned sales in the costume jewelry department for May are $86,000, and the planned stock-sales ratio is 3.6. On May 1, how much stock should be on hand? Round to the nearest dollar.
21. Given the forecast and booked orders shown in the table below, and a beginning inventory of 45, what is the master production schedule quantity for period 4 if you want to end period 4 with 0 inventory? Period 1 2 3 4 Forecasted Demand 70 65 60 55 Booked Orders 80 60 30 50 Projected ending inventory Master production schedule 70 60 65 Available to Promise 0 Group of answer choices 35 30 20 25
Suppose XYZ Company has the following aggregate demand requirements and other data for the upcoming four quarters. Quarter Demand Other Data 1 1300 Previous quarter’s output 1500 Units 2 1400 Beginning Inventory 200 units 3 1500 Stock out cost 50$ per unit 4 1300 Inventory holding cost 10 $ per unit Hiring Workers 4$ per unit Firing workers 8$ per unit Unit Cost 30$ per unit Overtime 40 $ per unit Question: Which of the following production plans is better: –Plan A—chase demand by hiring and firing –Plan B—produce at a constant rate of 1200 and obtain the remainder from overtime?
1. RBF, an emerging singer, is getting ready to cut his first album. The cost of recordingthe CD is Php 500,000 but copies are Php 500 apiece. If the album can be sold forPhp1,500 each, (a) how many CDs must be sold to break even? (b)What is thebreakeven point in dollars?RBF is confident that demand for his album will substantially exceed the break-evenpoint computed above. So, Mikey is contemplating having his album at a classier (andpricier) studio. The cost to record the CD would rise to Php 90,000. However, since thisnew studio works with very high volume, production costs would fall to Php 200 per CD.(c) What is the breakeven point for this new process?(d) Compare this process to the process proposed in the pre SHOW COMPLETE SOLUTION.
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.
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.] *
Q2: A company has seasonal demand, with the forecast for the next 12 months as given below. The current labor force can produce 500 units per month. Each employee can produce 20 units per month, and is paid $2,000 per month. The inventory carrying cost is $50 per unit per period. It costs $100 to hire or layoff an employee. Assume 200 units of initial inventory and we would like to keep the similar level at the end of the year. Month 1 3 4 7 8 9 10 11 12 Demand 660 700 840 700 660 500 600 840 80 900 700 600 Please use level and chase strategy to calculate the total cost of two plans (please show your work).
EFE company manufactures and sells boats. The company's management accountant gathered the following data to prepare budgets for 2012; Direct Materials Requirements Material A 12 metres per boat Material B 14 square meter per boat Inventory data of Direct Materials are; Beginning Inventory Material A 5.000 meters Material B 2400 square meters Inventory data of Finished Goods are; Beginning Inventory Target Ending Inventory Вoats 1.000 units 3.000 units Moreover, unit purchase price of material A was $60 and unit purchase price of material B was $10. For the coming year 2021 it is expected that unit purchase price of material A will be $64 and unit purchase price of material B will not change. The company uses FIFO inventory method. Labor hours required to produce 1 boat is 3 hours and the company plans to pay S12 per hour. Company budgeted manufacturing overhead rate of $6 per labor hour. Finally, the company expects to sell 4000 boats in 2021 at an average unit selling price of $6000.…
Problem 4. Considered a (s,S) system, with s = 80 and S = 200. The forecasted demand for the next 12 months is given in the following table. Initial inventory is 180, lead time is zero, and review is done at the end of every month. Find the order quantity. Mes, t 1 2 3 4 5 6 7 8 9 10 11 12 Demanda, D 65 110 | 80 150 120 90 50 170 140 125 55 80
9. The table below contains monthly (six months) demand estimates and working days per month. Month Demand Production Days JAN FEB MAR APR MAY JUN 1,500 20 1,200 24 1,000 25 1,600 25 1,100 20 1,300 26 For the implementation of "Level" strategy, the average demand (in units/day) over the six- month planning horizon is equal to; а. 40 b. 50 C. 55 d. 75
An investment proposal will have annual fixed costs of $60,000, varial costs of $35 per unit of output, and revenue of $55 per unit of output. i) Determine the break-even quantity. ii) What volume of output will be necessary for an annual profit of $60,000
Create a level plan with a zero ending inventory for the forecast shown in the table. There is no beginning inventory and regular production capacity is 300 units. Overtime costs K15 extra and is limited to 25 units per month and subcontracting is limited to 60 units per month and costs K10 per unit. Back orders cost KS0 per unit and there is a cost of KS per month to hold a unit in inventory. What is the total plan cost? |Month January February March Forecast 250 300 400 |April 350