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

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

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

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.
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…
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
a. Construct:i. ABC analysis by annual dollar usageii. ABC analysis by current inventory value(Performing the tables and charts in excel)b. Based on these analyses, do you think the firm is stocking the correct inventories?
A Pizza Company has a demand forecast for the next 12 months that is shown in Table 1 The current workforce of 100 staff can produce 1500 cases of pizzas per month. (a) Prepare a production plan that keeps the output level. How much warehouse space would the company need for this plan? (b) Prepare a demand chase plan. What implications would this have for staffing levels, assuming that the maximum amount of overtime would result in production levels of only 10 per cent greater than normal working hours? Table 1 demand forecast Month Demand (cases per month) January 600 February 800 March 1000 April 1500 May 2000 June 1700 July…
1. David Villa Manufacturing has the following demand aggregate requirements And other data for the next four periods: Quarter Forecast 1 1400 2 1200 3 1600 4 1500 COSTS/OTHER DATA Previous quarter’s output = 1,300 cases Beginning inventory = 0 cases Stock out cost = $50 per case Inventory holding cost = $10 per case at end of quarter Hiring employees = $40 per case Terminating employees = $80 per case Subcontracting cost = $60 per case Unit cost on regular time = $30 per case Overtime cost = $15 extra per case Capacity on regular time = 1,800 cases per quarter The three initial options he wants to evaluate are: Plan A: a strategy that hires and fires personnel as necessary to meet the forecast. Plan B: a level strategy. Plan C: a level strategy that produces 1,350 cases per quarter and meets the forecast demand with inventory and subcontracting. Which strategy is the lowest-cost plan? If you are…
APP Trial and Error -- Level Production Given the following forecasted demands with no capacity limits and no beginning inventory: Quarter Demand 200 900 1 234 Trial and Error is to be used to determine a production plan with a Level Production strategy. How many units will be produced by Regular Production in the 1st quarter? O.200 O 300 400 500 600 800 500 O 700
What are the advantages and disadvantages of varyingthe size of the workforce to meet demand requirementseach period?
Q4) A manufacturer provides specialized microchips. During the next 3 months its sales, costs, and available time are shown in the table. Month 1 Month 2 Month 3 There are no chips in stock at the beginning of the first month. It takes 1.5 hr of production time to produce a chip and costs $5 to store a chip from one month to the next. Determine a production schedule that meets the demand requirements, does not exceed the monthly production time limitations, and minimizes cost. Note that no chips should be in stock at the end of the 3 months. Use fmincon. Chips required Cost regular time ($/chip) Cost overtime ($/chip) Regular operation time (hr) Overtime (hr) 1000 100 110 2500 100 120 2200 120 130 2400 2400 720 2400 720 720
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
March demand was pridicted at 590 units of gear cycles of trevaa Itd. But the actual demand was 400 units only so fourth the company now want to forecast the april demand using exponential smoothing model with constant alpha of 0.72., calculate the same.
Problem 2: Week Forecast Customer Orders Projected On-Hand Inventory MPS Available-to-Promise On-hand Inventory schedule production whenever projected on-hand inventory drops below MPS lot size Complete the master production schedule based on the following information 160 160 30 300 1 120 110 2 100 100 3 130 75 4 110 50 5 140 32 6 140 11 7 170 5 8 180 0

SEE MORE QUESTIONS

Recommended textbooks for you

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

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