ruddymorales1123
18.02.2020 •
Business
Montpelier is planning its production of skis for the months of July, August, and September. Production capacity and unit production cost will change from month to month. Production levels should meet both demand forecasts and end-of-quarter inventory requirement in every month. Skis can be stored in a warehouse to satisfy demand in later months. An inventory holding cost will be incurred in that case. Initial inventory at the beginning of July = 200 pairs. Ending inventory required at the end of September =800 pairs. Holding cost per month per ski is $0.5.Month Demand Production Capacity Unit Production CostJuly 300 1000 25August 500 800 26September 700 400 29Management would like to schedule production to minimize its costs for the quarter.(a) Formulate the problem mathematically by clearly defining the decision variables, objective function and constraints.(b) Implement this problem in excel to solve for the optimal solution.
Solved
Show answers
More tips
- A Animals and plants 10 Tips for Growing Delicious and High-Quality Tomatoes in Your Garden...
- H Health and Medicine Tick Traps: How to Remove Them Safely and Effectively...
- F Family and Home How to Keep Your Home Warm: Tips and Tricks...
- C Computers and Internet How Much Does an iPhone Cost in America?...
- S Style and Beauty Discover the Art of Nail Design: How Do You Paint Your Nails?...
- F Food and Cooking Discover How to Properly Prepare Dough for Rasstegai...
- F Family and Home Ways to Attract Wealth into Your Home...
- G Goods and services Stock center - a modern way of optimizing logistics...
- F Family and Home How to Teach Your Child to Read?...
- F Food and Cooking How to properly cook shrimp: tips from professionals...
Answers on questions: Business
- B Business You are an economic consultant and have been contacted by an official from a developing country. She tells you that her country’s economy is currently growing at 2 percent per year....
- B Business Which is a risk in IS development?...
- B Business Read the case study, Business Model and Competitive Strategy of IKEA in India, from the Deresky textbook Part 3 Comprehensive Cases. Analyze the content and prepare a paper addressing...
- B Business Hoi Chong Transport, Ltd., operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 126,000 kilometers during a year, the average operating...
- B Business At the end of 2020, Payne Industries had a deferred tax asset account with a balance of $95 million attributable to a temporary book-tax difference of $380 million in a liability...
- B Business Western Electric has 33,500 shares of common stock outstanding at a price per share of $82 and a rate of return of 12.85 percent. The firm has 7,450 shares of 8.10 percent preferred...
- B Business Caro has $10,000 to invest. Her best friend, Imelda, happens to be a stockbroker. Imelda tells Caro that her investments should be diversified. To make sure that Caro understand...
- B Business The contribution margin approach managers in short-term decision making because it...
- B Business The contract will be awarded to meets our qualifications. whomever whoever...
- B Business The concept of creating safer and more efficient equipment is called...
Ответ:
1. Mandy may need to raise a finance because she wants to expand her business, so therefore she may need extra money.
2. 1 advantage of taking out a bank loan is that she could build up her business with the money she’s taking out and the disadvantage is that her business may not work out or she won’t be able to pay the bank back
3. It may be a good idea to finance the business expansion because she may or may not grow her business after expanding it. But after expanding it there is possible chances of her business working out and growing more.
Explanation: