As the owner of a fast food restaurant with declining sales, your customers are looking for something new and exciting on the menu. Your market research indicates that they want a burger that is loaded with everything as long as it meets certain health requirements. Money is no object to them. Use Excel to answer this question Requirements: Must include at least one of each item and no more than six of each item Must use whole items (no half or partial servings) Final burger must contain no more than: 3,000 mg of sodium 50 g of fat 3,000 calories Must keep the servings of ketchup and lettuce the same Must keep the servings of pickles and tomatoes the same Must use exactly two buns a. What is the most expensive burger you can make that meets these requirements? b. What are the allocations of each ingredients.

As the owner of a fast food restaurant with declining sales, your customers are looking for something new and exciting on the menu. Your market research indicates that they want a burger that is loaded with everything as long as it meets certain health requirements. Money is no object to them. Use Excel to answer this question Requirements: Must include at least one of each item and no more than six of each item Must use whole items (no half or partial servings) Final burger must contain no more than: 3,000 mg of sodium 50 g of fat 3,000 calories Must keep the servings of ketchup and lettuce the same Must keep the servings of pickles and tomatoes the same Must use exactly two buns a. What is the most expensive burger you can make that meets these requirements? b. What are the allocations of each ingredients.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.4: Multiple Regression Models

Problem 12P

See similar textbooks

Similar questions

Lefola Limited is the only manufacturer of product G_Easy in the Popa Land. It has provided documented levels of demand at certain selling prices for product G_Easy which are as follows:Price per unit 7 0006 000Demand Units 01Total costs 3 0005 000875 000 2 4 000 3 3 000 4 2 000 5 1 000 68 000 12 000 17 000 23 000 30 000Required:MGA40AT/POF117V – 2020 Instructional Teaching manual packUsing a tabular approach, calculate the marginal revenues and marginal costs for product G_Easy at the different levels of demand, and so determine the selling price at which Lefola Limited’s profits are maximized.
In 2020, a manufacturing company instituted a total quality management (TQM) program producingthe comparative report shown below:[LO 17-5]Summary COQ Report(in thousands)2019 2020 % ChangePrevention costs $ 200 $ 300 +50Appraisal costs 210 315 +50Internal failure costs 190 114 −40External failure costs 1,200 621 −48Total COQ $1,800 $1,350 −25On the basis of this report, which one of the following statements is most likely correct?a. An increase in conformance costs resulted in a higher-quality product and, therefore, a decreasein nonconformance costs.b. An increase in inspection costs was solely responsible for the decrease in quality costs.c. Quality costs such as scrap and rework decreased by 48%.d. Quality costs such as returns and repairs under warranty decreased by 40%.e. Nonconformance costs increased by 50% and conformance costs decreased by approximately 47%.
The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 126.0625 (thousand units).Fill in the missing values assuming there is no trend.Round seasonal indexes to 4 decimal places.Report Averages accurate to at most 2 decimal places.Report Actual sales ('000) accurate to the nearest integer. Year 1 Year 2 Year 3 Year 4 Average Seasonal Index Quarter 1 92 93 95 106 Quarter 2 105 106 105 101 Quarter 3 197 187 196 1.5211 Quarter 4 106 116 121 0.8865 PART BSuppose actual quarterly sales (in thousands) for Year 5 are 93, 123, 206, and 126 respectively. Assuming there is no trend, forecast sales for the four quarters of Year 5.Use seasonal indexes (rounded to 4 decimal places) from Part A.Report forecast answers as integers accurate to the nearest thousand.Quarter 1 forecast = thousandQuarter 2 forecast = thousandQuarter 3 forecast = thousandQuarter 4 forecast =…
Company X produces a product, GlueX3, that Company X sales for $5. An opportunity presents itself to reallocate its manufacturing facility and related resources to produce Epoxy10. It believes it can sell Epoxy10 for $8. Explain how this switch creates “value”. Be sure to include for whom.
16.6 which type of graph would you recommend to show each of the following? why? A. A comparison of changes in average annual per capita income for the United States and japan from 2000 to 20018. B. The percentage compositiion of average family expenditure patterns, by the major types of expenditures, for families whose heads are under age 35 compared with families whose heads are 55 or older. C. A comparaison of the changes in charitable giving between December 21, 2007 and December 31, 2017.
b. The following table shows the number of televisions sold over the last ten years at alocal electronic store.YEAR TV SALES1 1502 3003 4804 6005 6306 6407 7008 8259 90010 980i. Using trend projection, develop a formula to predict sales for years 11 and 12. Youhave to show all working. You will need to develop a table to calculate the slope andthe intercept. ii. Use that formula to forecast television sales for years 11 and 12.
. How would you respond to the criticism that EOQ models tend to provide misleading resultsbecause values of D, S, and H are, at best, educated guesses?
We all hate to keep track of small change. By us-ing random numbers, it is possible to eliminate the need for change and give the store and the customera fair deal. This problem indicates how it couldbe done.a. Suppose that you buy something for $0.20. Howcould you use random numbers (built into the cashregister system) to decide whether you should pay$1.00 or nothing?b. If you bought something for $9.60, how wouldyou use random numbers to eliminate the need forchange?c. In the long run, why is this method fair to both thestore and the customers? Would you personally (asa customer) be willing to abide by such a system?
b. The following table shows the number of televisions sold over the last ten years at alocal electronic store. YEAR TV SALES 1 1502 3003 4804 6005 6306 6407 7008 8259 90010 980 i. Using trend projection, develop a formula to predict sales for years 11 and 12. Youhave to show all working. You will need to develop a table to calculate the slope andthe intercept. ii. Use that formula to forecast television sales for years 11 and 12.
Some new product launches fail and this leaves a negative impact on the profitability of the company. Using a particular product as an example, discuss1. Some of the key determinates and conditions that need to be met to launch that product successfully on the market; 2. What may go wrong with the launch of that product and why? 3. What steps should the company launching the product take in order to mitigate product launch failure or to address the situation in the event of a failure of the launch of that product
3. As an owner of a restaurant known as Ryuichi House, you have decided to break down the salesof the club into four categories, the first category is beverages. Your estimate of beverages salesis that 30,000 drinks will be served. The selling price for each unit will average 60Php; cost is30Php. The second category is meals, which you expect to be 10,000 units with an average priceof 400Php and a cost of 200Php. The third category is desserts, of which you also expect to sell10,000 units but with an average price of 100Php per unit sold and cost of 40Php per unit. Thefinal category is snacks, which you expect to total 20,000 units at an average price of 250Php witha cost of 130Php. You will also expense 72,000Php for rent, 8,000Php for utilities, and 80,000Phpfor the entertainment.a. How much is the total sales?b. What is your break-even point in pesos per month?
Clippers Inc. (CI) manufactures two types of garden clippers. A light-duty model, called the “half-inch,”is intended for clipping branches and stems up to one-half inch thick. The “one-inch” model is designedfor heavier stems and branches. To boost sales, CI decided at the beginning of the current year to reducethe price of the half-inch model to better position its price relative to some key competitors. On the otherhand, CI felt that the one-inch model was technically superior to competitors’ models and decided that asmall price increase was appropriate. The data for the current and prior year are as follows:Current Year Prior YearSales units 7,200 6,500Sales mix for each productHalf-inch model 50% 30%One-inch model 50% 70%PriceHalf-inch model $12.00 $14.00One-inch model $36.00 $32.00Variable cost per unitHalf-inch model $6.00 $6.00One-inch model $8.00 $8.00Fixed cost $35,000 $35,000Required1. Prepare a comparative contribution income statement for CI for the current year that shows…