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 had changed for the company since the last case

what had changed for the company since the last case? 2. How do you account for the dramatic rise in Apple following the death of Steve Jobs, and its dramatic fall this semester?

  Some have argued the six sigma programs are merely

Some have argued the Six Sigma programs are merely repackaged versions of older quality improvement programs that originally accompanied TQM initiatives in the 1980s

  Assume production and demand occur at constant rates

Decided to set up a small production facility in Sydney to sell to local restaurants that want to offer gelato on their dessert menu. To start simple, he would offer only three flavors of gelato: fragola (strawberry), Chocolato (chocolate), and bacio..

  Formal company e-mails to employees

Acting as supervisor for a company of your choice, draft two examples of formal company e-mails to employees.

  What are the advantages and disadvantages of pay

What are the advantages and disadvantages of pay for knowledge pay programs.

  Draft a dfd for patient admission in a hospital

Information flow diagrams provide a way for the system to be broken down into manageable parts beginning with a general context and moving into more detail. Draft a DFD (Information flow diagrams) for Patient admission in a hospital.

  Direct versus indirect distribution

Once you have developed your product/service, you then need to determine how to make it available to the end user. Using your textbook and the articles from the Databases

  Compute labour-material-machine also overhead productivity

who can produce an average of 30 also 50 devices of 1st also 2nd types per day. Workers receive $10 per day also machine also overhead cost is $120 also $100 per day respectively. a. Compute Labour, material, machine also overhead productivity.

  How much time should one investigate a company

How much time should one investigate a company before doing business with them?

  Illustrate what is the annual cost for ordering item x

Every time an order is placed for more items X, it costs $10. Whenever item X is ordered, Illustrate what should be the order size. Illustrate what is the annual cost for ordering item X.

  Is volvo approach to evaluating the effectiveness

Is Volvo's approach to evaluating the effectiveness of its virtual teams one that could serve as a useful model for other organizations to follow in evaluating their own virtual teams.

  How many machines should be purchased to meet the upcoming

How many machines should be purchased to meet the upcoming year's demand without resorting to any short-term capacity solution?

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