Data cells-changing cells-output cells and objective cell

Assignment Help Operation Management
Reference no: EM13784378

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 are needed? What are the decisions that need to be made? What should the objective be?

b. Suppose that Fairwinds were to participate in Project A fully and in Project C at 50 percent. Calculate by hand what the ending cash positions would be after year 1 and year 2.

 

c. Make a rough sketch of a spreadsheet model, with blocks laid out for the data cells, changing cells, output cells, and objective cell.

Reference no: EM13784378

Questions Cloud

Is any one type of theory more valid than the others : Is any one type of theory more valid than the others? Why or why not? What are the differences and similarities (if any) between theory and hypothesis
Demand for boots is highly seasonal : 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 curren..
View of the biopsychosocial approach : Discuss your view of the biopsychosocial approach. What specifically interests you and why does it? Does consideration of spirituality and culture enhance or impede your understanding of human behavior? Identify and discuss factors that influence ..
What is the government’s audit plan : Normal 0 false false false EN-US X-NONE X-NONE What is the government’s aud..
Data cells-changing cells-output cells and objective cell : 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 curren..
Underlying principles of erikson theory : You have been hired as a consultant by an advertising firm that is developing a series of commercials for a family-oriented theme park. The commercials will target family members at various life stages. You have decided that understanding Erikson'..
How is a power of attorney used in personal lives : How is a power of attorney used in personal and professional lives? What are some benefits and struggles associated with power of attorneys
Evaluate the main effects and the interaction : Do the results indicate that self-esteem is significantly higher on average for males at significance level of 0.01 - Evaluate the main effects and the interaction at a level of significance of 0.05.
Essential points of the philosopher work : Identify a philosopher and corresponding philosophical texts that apply to a situation or concern in the contemporary world. The philosopher about whom you write must have been covered by this course.

Reviews

Write a Review

Operation Management Questions & Answers

  What are the various facets of the job of an arbitrator

What are the various facets of the job of an arbitrator? Cite examples of ethical considerations, past practice, fairness, and other traits and responsibilities.

  Determine the cost of the chiefs plan

Evaluate the current staffing plan. What does it cost? Are 26 officers sufficient to handle the normal workload? Determine the cost of the Chiefs plan. Do you need to implement the Chief's plan or can the current staff handle the load? Explain your ..

  Be specific and precise in your recommendation

Be specific and precise in your recommendation and support it with both facts and reason. Keep in mind this is NOT about your preferenceâ€"BK is not interested in what you feed your kids but what America feeds theirs.

  Payoff analysis stage in the operations consulting process

Which of the following operations consulting tools are used in the cost impact and payoff analysis stage in the operations consulting process

  How much safety stock would be required at the dc

The chain is considering centralizing the inventory of the T650 to a distribution center that will serve all 49 stores. How much safety stock would be required at the DC to provide the same cycle service level of 90%

  Discuss porter industry analysis forces

THE FUTURE OF GAP, INC. CASE ABSTRACT Founded in 1969 by Donald Fisher, Gap, Inc. was a leading specialty retailer operating primarily in North America offering clothing, accessories, and personal care products under the Gap, Banana Republic, and Old..

  How is a project baseline used to guide the execution

How is a project baseline used to guide the execution of the project's work, to evaluate progress and performance, and to control the project?

  Discuss the ethical violations

Discuss the ethical violations concerning CVS Pharmacy banning tabacco products in their stores. Does this make sense from a "market system" perspective.

  Consider the ethical aspects of implementing a change

Why is it important to consider the ethical aspects of implementing a change? What are some ethical implications of implementing a change? What ethical issues can arise from personal or organizational motives when implementing a change?

  Illustrate what leadership actions you would take to adapt

Illustrate what Leadership actions you would take to adapt your business should subsequent happen in first three years of operations.

  Who should write the sow

One of the most important outputs from the plan procurement process is the procurement statement of work (SOW). Who should write the SOW? How detailed should it be? Why is this important?

  Explain what capabilities of an erp system

What capabilities of an ERP system would be useful for a company like Just Sofas. Describe the environment under which the ERP system was being implemented. Was due diligence conducted in choosing the ERP vendor.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd