The increase in sales from the rebate that would make the rebate and price cut equally desirable. Price cut: Price cut is the cutting down the price of a product. It is usually done to increase sales and improve the market share of a product. Price rebate: Price rebate is when a certain amount of the purchase price is returned to the buyer after the buyer has purchased a certain volume of a product.

Question

The University of the West Indies GLOBAL CAMPUS MGMT 2026 Production and Operations Management - Problem Sheet Assignment Semester II 2024/2025 Note: Although this assignment is being currently assessed out of 100 marks it would be prorated to Contribute a maximum of 40% towards your final course marks. M&H company ltd. sells television sets and has collected monthly sales data (in units) for the past 12 months as shown in table 1below: TABLE 1 Month Sales (Units) 1 120 2 135 3 150 165 5 180 200 7 195 8 210 225 10 240 11 255 12 270 This Assignment is comprised of four (4) Questions - All questions must be attempted Using the data provided, answer the following questions: a. Using a 3-month weighted moving average with weights 0.5, 0.3, and 0.2 (most recent month having the highest weight), calculate the forecast for month 13. [2 marks] Screens 5-7 of 7

Answer 1

Question

Chapter 2, Problem 27P

a)

Summary Introduction

To determine: The increase in sales from the rebate that would make the rebate and price cut equally desirable.

Price cut:

Price cut is the cutting down the price of a product. It is usually done to increase sales and improve the market share of a product.

Price rebate:

Price rebate is when a certain amount of the purchase price is returned to the buyer after the buyer has purchased a certain volume of a product.

b)

Summary Introduction

To perform: A sensitivity analysis that could be used to help determine the best decision for Company D.

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

The University of the West Indies GLOBAL CAMPUS MGMT 2026 Production and Operations Management - Problem Sheet Assignment Semester II 2024/2025 Note: Although this assignment is being currently assessed out of 100 marks it would be prorated to Contribute a maximum of 40% towards your final course marks. M&H company ltd. sells television sets and has collected monthly sales data (in units) for the past 12 months as shown in table 1below: TABLE 1 Month Sales (Units) 1 120 2 135 3 150 165 5 180 200 7 195 8 210 225 10 240 11 255 12 270 This Assignment is comprised of four (4) Questions - All questions must be attempted Using the data provided, answer the following questions: a. Using a 3-month weighted moving average with weights 0.5, 0.3, and 0.2 (most recent month having the highest weight), calculate the forecast for month 13. [2 marks] Screens 5-7 of 7

Gas sales across type: 80% of gas sales tend to be regular. 15% midgrade, 5% tend to be premium. $0.10 increase in price per gallon tends to decrease gallons sold by 1 to 3%. Jan-0.87, Feb-0.95, Mar-1.00, Apr-1.05, May-1.08, Jun1.15, Jul-1.13, Aug-1.07, Sep-1.02, Oct-0.94, Nov-0.89, Dec-0.85. You want the MAPE to be below 20%, if ypu can get it to or below 10% they'll throw in extra $10k. Wont get bonus if it is above 11% or 20%. It cannot be over 20%.

help me choose the correct path please. There are other options