Question

In: Operations Management

ABC Company is creating the production plan for the coming month. The company has collected the...

ABC Company is creating the production plan for the coming month. The company has collected the following data on the average marketing demand during the past 25 months. Month Demand 1 60 2 65 3 67 4 58 5 59 6 56 7 65 8 65 9 69 10 65 11 70 12 71 13 64 14 75 15 70 16 72 17 65 18 77 19 62 20 59 21 78 22 58 23 60 24 68 25 59 Using a three-month moving average, forecast demand for month 26. Using a three-month weighted average with the most recent month weighted 0.61, the next most recent month weighted 0.29, and the third month weighted 0.1, forecast the demand for month 26. Compute an exponentially smoothed forecasting using α = 0.39 and forecast the demand 26. Compare the forecast in (a), (b), and (c) using MAD. Indicate the most accurate forecasting method. Compute the tracking signal for the most accurate method (based on MAD value), and construct a control chart. Comment on the forecasting result.

use excel and screenshot along with formulas used

Solutions

Expert Solution

(Please like the answer it will encourage me. Do comment if any correction required before disliking.)


Related Solutions

A software company is creating a scheduling plan for a nine-month project,. The company has 30...
A software company is creating a scheduling plan for a nine-month project,. The company has 30 of its own full-time employees and can assign them to the project. For any shortage of personnel, the company will hire short-term contract employees. Company employees earn $5,500 per month, while short-term contract employees make $8,000/month. Contract employees can be assigned to the project beginning in any month, and their contract period is two months. The number of workers required for the project by...
ABC Inc. has projected sales and production in units for the second quarter of the coming...
ABC Inc. has projected sales and production in units for the second quarter of the coming year as follows: April May June sales....... 50,000 40,000 60,000 production..... 60,000 50,000 50,000 cash related production costs are budgeted at $5 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $100,000 per month. The accounts payable balance on March 31...
ABC Company. has the capacity to produce 15,000 lamps each month. Current regular production and sales...
ABC Company. has the capacity to produce 15,000 lamps each month. Current regular production and sales are 12,000 lamps at a selling price of $16 each. The costs of making each lamp is: direct materials $5.00 direct labor 3.00 variable overhead 1.00 fixed overhead 1.25 variable selling costs 0.20 fixed selling costs 0.75 ABC Company has received a special order who wants to buy 6,000 lamps at a reduced price of $13 per lamp. ABC Company has determined that there...
ABC Company estimates the following data for the coming month: total variable costs $60,000.00, income tax...
ABC Company estimates the following data for the coming month: total variable costs $60,000.00, income tax rate 30%, contribution margin percentage 60%. Find the estimated total sales for the coming month. a. $100,000 A GUESS b. $60,000 / 40% c. $60,000 / 60% d. $60,000 X 60% Type or paste question here
ABC company are comparing 2 method of production plan. Method A requires $8 of materials and...
ABC company are comparing 2 method of production plan. Method A requires $8 of materials and 11 minutes of both labor and machinery per unit produced. Method A also requires $113363 in fixed cost to set up. Method B requires $11 of materials and 17 minutes of both labor and machinery per unit produced. Method B is easier to setup, with only $84819 in fixed cost. There are additional fixed costs of $262466 incurred regardless of which method is selected....
Suppose that the ABC Corporation has a production (and sales) capacity of $1,000,000 per month. Its...
Suppose that the ABC Corporation has a production (and sales) capacity of $1,000,000 per month. Its fixed costs – over a considerable range of volume – are $350,000 per month, and the variable costs are $0.50 per dollar of sales. What is the annual break even chart (D’)? Develop (graph) the break even chart. What would be the effect on D’ of decreasing the variable cost per unit by 25% if the fixed costs thereby increased by 10%? What would...
Tilson Company has projected sales and production in units for the second quarter of the coming...
Tilson Company has projected sales and production in units for the second quarter of the coming year as follows:                                                 April                May                 June Sales                                        55,000             45,000             65,000 Production                              65,000             55,000             55,000 Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $110,000 per month. The accounts payable balance on March...
Frazier Manufacturing Company collected the following production data for the past month: Units Produced Total Cost...
Frazier Manufacturing Company collected the following production data for the past month: Units Produced Total Cost 1,600 $66,000 1,300 57,000 1,500 67,500 1,100 49,500 If the high-low method is used, what is the monthly total cost equation? A. Total cost = $0 + $45/unit B. Total cost = $13,200 + $33/unit C. Total cost = $16,500 + $30/unit D. Total cost = $9,900 + $36/unit I know the answer is $13,200+33/unit. But I do not see how the math is...
Cost of Quality Analysis The ABC Company has collected the following cost data for the year:  ...
Cost of Quality Analysis The ABC Company has collected the following cost data for the year:             Receiving Inspection $ 15,232 Production Scrap $   32,150 Rejected Products $ 6,200   Product Design $ 25,422 Customer Adjustment Credit $ 85,654 Online Inspection $ 17,248 Quality Team Meeting $ 7,540 Downgrading Products $ 1,125,328 Customer Need survey $ 3,250 Final test $         25,758 Prototyping $ 136,802   Organize these costs in COQ categories and put any non-QOC data in the NQ category. Compute the...
The Janesky Company has collected data on the manufacture of 3,186 robot grippers last month. The...
The Janesky Company has collected data on the manufacture of 3,186 robot grippers last month. The breakdown of total costs is shown below. They now need to plan for future months. Units sold last month 3,186 Direct materials $108,929 Direct labor $230,317 Manufacturing variable overhead $116,761 Selling and administrative costs $240,933 1. What was the total cost per unit? 2. What was the variable cost per unit? 3. Janesky is forecasting that 8,875 units will be produced and sold without...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT