math
posted by Anonymous .
Reboot, Inc. is a manufacturer of hiking boots. Demand for
boots is highly seasonal. In particular, the demand in the next year
is expected to be 3,000, 4,000, 8,000, and 7,000 pairs of boots in
quarters 1, 2, 3, and 4, respectively. With its current production facility,
the company can produce at most 6,000 pairs of boots in any
quarter. Reboot would like to meet all the expected demand, so it
will need to carry inventory to meet demand in the later quarters.
Each pair of boots sold generates a profit of $20 per pair. Each pair
of boots in inventory at the end of a quarter incurs $8 in storage
and capital recovery costs. Reboot has 1,000 pairs of boots in inventory
at the start of quarter 1. Reboot’s top management has
given you the assignment of doing some spreadsheet modeling to
analyze what the production schedule should be for the next four
quarters and make a recommendation.
(a) Visualize where you want to finish. What numbers will top
management need? What are the decisions that need to be
made? What should the objective be?
(b) Suppose that Reboot were to produce 5,000 pairs of boots in each
of the first two quarters. Calculate by hand the ending inventory,
profit from sales, and inventory costs for quarters 1 and 2.
(c) Make a rough sketch of a spreadsheet model, with blocks laid out for the data cells, changing cells, output cells and target cells
Respond to this Question
Similar Questions

ecomonics
I am trying to understand the math part of supply and demand . I am not getting it,I really need help! The question is: The demand and supply functions for sweatshirts are as follows: DEMAND Supply Quanity Quanity demanded(per period) … 
6th grade
boots belonging to their dad does that turn into their dads' boots? 
finance
One yaer fom now, how much value creation is expected from the expansion? 
Managerial Accounting
Rocky Mountain Outfitters manufactures cowboy boots. Information related to a recent production period is as follows: Estimated manufacturing overhead, 2004 $240,000 Estimated machine hours, 2004 12,000 Direct labor cost, September … 
healthcare fiancare
HINT: 6% X $1,000,000 – {20% X ($1,000,000 – (6% X $1,000,000))} = 6% X $1,000,000 – {20% X ($1,000,000  $60,000))}= 6% X $1,000,000  {20% X $940,000}= 6% X $1,000,000  $188,000 = $60,000  $ 188,000= $128,000 A) The interst … 
math
vickie earns $20,000 a year as a bookkeeper.if she receive a raise of 2%,how could her new total salary be represented? 
Math
Would 72,060,964,765 look like the following in it's expanded form? 
Inroduction to Managment Science
reboot inc, manufacturer of hiking boots. make a rough sktch of a spreadsheet model, with blocks laid out for the data cells changing celss, ouput cells, and target cells. 
math
The data set represents the income levels of the members of a country club. Estimate the probability that a randomly selected member earns at least $98,000. 112,000 126,000 90,000 133,000 94,000 112,000 98,000 82,000 147,000 182,000 … 
statistics
The data set represents the income levels of the members of a country club. Estimate the probability that a randomly selected member earns at least $98,000. 112,000 126,000 90,000 133,000 94,000 112,000 98,000 82,000 147,000 182,000 …