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

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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