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

  1. 👍
  2. 👎
  3. 👁

Respond to this Question

First Name

Your Response

Similar Questions

  1. Probability

    1. The chart below shows the possible options for pants, shirts, and shoes in Tom’s closet. Which tree diagram correctly shows the possible outfits he can wear? Pants- jeans(j) khakis(k) Shirts- yellow(y) blue(b) checked(c)

  2. algebra

    The regional manager of a chain of department stores created the following stem-and-leaf plot showing the number of pairs of boots at each of the stores: I 0 I I 1 I 7 8 I 2 I 0 5 8 I 3 I 4 4 7 8 I 4 I 0 I 5 I I 6 I Key: 1 I 7 =

  3. English

    Which sentence has a dangling modifier? A) Inexpensive and fun, camping is a great way to spend a weekend. B) Sturdy yet comfortable, my new hiking boots will enable me to explore on foot. C) While looking for a campsite, a

  4. Math

    Jenny has six blouses, four different skirts, 20 different pairs of socks, and four pairs of shoes in her closet at the end of the week. why the methods used in the previous two problems would be inefficient in determining the

  1. LA Check please

    which is the best paraphrase of these lines from "January"? Fat Snowy Footsteps Track the floor, A)Thick, snowy footprints show where animals walked B)Thick, snowy outlines of feet mark the floor ****** C)Large snow boots lie on

  2. social studies

    suppose you are at 15 south latitude, 145 east longitude. which would be more useful-gear pr hiking boots? why

  3. math

    A pair of boots has an original price of $95. They are on sale for 35 percent off. What number can you multiply $95 by to equal the discounted price of $61.75?

  4. Algebra Readiness

    the sales tax rate is 6.9% A: find the tax paid for a pair of boots with a list price of $128 B: what is the total cost of the boots PLZ HELP VERY URGENT AND IM SUPER STUMPED!!!!!!!

  1. English

    I need your help to paraphrase the description of the Merchant in Chaucer's Prologue to the Canterbury Tales. I'll include the description at the end. Thank you . 1)The merchant had a forking beard and wore a motley (I need a

  2. english

    Which sentence uses correct parallel construction? A. Anyone who is going to work here will have to be athletic, an intelligent person, and have a good sense of humor. B. Most people enjoy ice cream and the plant grows. C. The

  3. English

    is "six inches of snow are predicted, I'd better find my boots" a run on, simple or compound sentence. I am pretty sure its not a compound because there is no coordinate conjunction but i am not sure if it is a simple or run on

  4. Algebra

    What percent of 25 is 10? A)10=x•25;40% ** B)10=x•25;250% C)25=x•10;4% D)25=x•10;250% The sales tax is 6.9% A.Find the tax paid for a pair of boots with a list price of $128. B.What is the total cost of the pair of boots.

You can view more similar questions or ask a new question.