Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. can someone help with doing this on excel? .. 13

Can someone help with doing this on excel? .. 13.9 The S&OP team...

50.1K

Verified Solution

Question

Accounting

imageCan someone help with doing this on excel?

.. 13.9 The S&OP team at Kansas Furniture, has received the following estimates of demand requirements: July Aug. Sept. Oct. Nov. Dec. 1,000 1,200 1,400 1,800 1,800 1,800 Stephanie Klein-Davis/The Roanoke Times/ AP Images a) 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 these two plans on an incremental cost basis: Plan A: Produce at a steady rate (equal to minimum require- ments) of 1,000 units per month and subcontract additional units at a $60 per unit premium cost. Plan B: Vary the workforce, to produce the prior month's demand. The firm produced 1,300 units in June. The cost of hiring additional workers is $3,000 per 100 units produced. The cost of layoffs is $6,000 per 100 units cut back. Note: Both hiring and layoff costs are incurred in the month of the change, (i.e. going from production of 1,300 in July to 1,000 in Au- gust requires a layoff (and related costs) of 300 units in August, just as going from production of 1,000 in August to 1,200 in September requires hiring (and related costs) of 200 units in September). PX b) Which plan is best and why

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students