The manufacturing company Highlands Archery has forecast the demand for the Grizzly compound bow for the next 4 months. The production manager at High- lands Archery has already created an aggregate production plan, based on that information: Month 1 Month 2 Month 3 Month 4 Demand 10,000 bows 5,000 bows 30,000 bows 50,000 bows Produce 25,000 Produce 25,000 Produce 25,000 Produce 25,000 Managers production plan bows bows bows bows a. If Highlands Archery uses the manager's production plan, how many bows would be in inventory at the end of the fourth month? b. Following this plan, which month has the highest average inventory? c. If Highlands Archery pays $1 per bow to keep a bow in inventory for 1 month, what is the total inventory cost of the manager's plan, based on monthly ending inventory?

The manufacturing company Highlands Archery has forecast the demand for the Grizzly compound bow for the next 4 months. The production manager at High- lands Archery has already created an aggregate production plan, based on that information: Month 1 Month 2 Month 3 Month 4 Demand 10,000 bows 5,000 bows 30,000 bows 50,000 bows Produce 25,000 Produce 25,000 Produce 25,000 Produce 25,000 Managers production plan bows bows bows bows a. If Highlands Archery uses the manager's production plan, how many bows would be in inventory at the end of the fourth month? b. Following this plan, which month has the highest average inventory? c. If Highlands Archery pays $1 per bow to keep a bow in inventory for 1 month, what is the total inventory cost of the manager's plan, based on monthly ending inventory?

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

Create Business Plan about Vending Machines. Must includes:- 1. The product/service (advantage and disadvantage)2. Marketing and distribution (4p’s)3. The investment opportunity (financing history, exit strategies and etc)
Define any 2 mangement theories.
a. Different types of Organizational Plans
Explain what is 3E and what do they consist of
Explain the Eared value in detail
Identify the major planning decisions in production andoperations management.
help
4
Brief description of flexible Approach
What are Cost-Oriented Tactics?