Question

In: Mechanical Engineering

Q] The historical actual sales of an item purchased by a factory is given below. What...

Q] The historical actual sales of an item purchased by a factory is given below. What would have been the forecast had the manager a) used 3 period moving average to make the forecast in the past, and b) used exponential smoothing with alpha=0.2 to make the forecast in the past. Show all calculations. PLEASE PROVIDE TABULATED EXCEL CALCULATIONS.

Month Actual Sales
1 45
2 48
3 37
4 40
5 43
6 37
7 46
8 48
9 42

Sub: Material Science

Solutions

Expert Solution

samet mamat answered 3 years ago
Next > < Previous

Related Solutions

Below is the variance report Prior year Item Budget Actual Variance Variance % Actual Days in...
Below is the variance report Prior year Item Budget Actual Variance Variance % Actual Days in time period 31 31 31 Staffed Beds 20 20 20 Patient days 527 498 (29.0) -5.5% 415 Total RN FTEs 45.1 50.1 (5.0) -11.1% 36.7 Revenue: Gross patient revenue $460,450 $441.932 ($18,518) -4.0% $417,883 Personnel Expense: Total salaries and wages $171,920 $192,845 ($20,925) -12.2% $141,552 Benefits $51,576 $52,797 ($1,221) -2.4% $42,466 Total personnel expenses $223,496 $245,642 ($22,146) -9.9% $184,018 Overtime wages % 2.0% 6.1%...
Given the information below, What is the total variance in the actual and static budget? DeFleur...
Given the information below, What is the total variance in the actual and static budget? DeFleur manufactures bicycles. The bicycles are manufactured in two divisions. In the framing division, the carbon bicycle frames are manufactured. In the assembly division, the components are assembled to the frame and the bike is ready for sale. There is no market for the unassembled frames and all manufactured frames are transferred to the assembly division. For the purposes of performance evaluation, the framing division...
Create a popularity index for the sales history given below. Menu Item Number Sold Popularity Index...
Create a popularity index for the sales history given below. Menu Item Number Sold Popularity Index Veal Marsala 375 Strip Steak 330 Roast Chicken 125 Stuffed Shrimp 160 Pasta Alfredo 130 Pork Chops 80 Saute Liver 90 Beef Stew 170 Deluxe Burger 405 Grill Swordfish 135 Totals 100% 8. (10 points) Now complete a production schedule using the popularity index and accounting for a 10% increase in sales that the chef expects due to a holiday. Menu Item Total Forecast...
. Below is information about actual sales of a product for June and July and the...
. Below is information about actual sales of a product for June and July and the expected sales of August, September and October. Selling price for the product is $100. June $230,000, July $240,000, August $220,000, September $280,000 and October $310,000. November $340,000 Costs of Goods Sold equals to 70% of Sales. The end of inventory policy is 40% of the next month of quantity sales.   Inventory is purchased on continuous basis during the month. 60% of inventory costs are...
What was the actual impact and historical significance of the meat/food industry brought about by The...
What was the actual impact and historical significance of the meat/food industry brought about by The Jungle by Upton SInclair?
The following actual data was given for the firm. 8,000 pounds of material were purchased costing...
The following actual data was given for the firm. 8,000 pounds of material were purchased costing $ 40,000 Four hundred units were produced requiring 900 labor hours costing $5,400 and 1, 000 pounds of material . The standard for labor is 2 hours per unit with a wage rate of $5 per hour and for materials 2 pounds per unit at a price of $6 per unit. A) 10% - Calculate all labor variances B) 10%-- Calculate all material variances...
You are given the following static budget report: Budget            Actual              Variance Unit Sales  &nbsp
You are given the following static budget report: Budget            Actual              Variance Unit Sales                                           10,000               15,000             5,000 F Variable Expenses:     Commissions                                  $30,000 $33,000 $3,000 U     Advertising                                      $1,000 $1,200 $200 U     Travel                                              $10,000 $11,000 $1,000 U     Samples                                          $2,500 $2,300 $200 F Total Variable                                     $43,500 47,500 $4,000 U Fixed Expenses     Rent                                                 $5,000 $5,000 0     Salaries – Sales                               $2,000 $2,000 0     Salaries – Office                              $1,200 $1,200 0     Depreciation                                    $1,500 $1,500 0 Total Fixed                                          $9,700 $9,700             0 Total Expenses $53,200 $57,200 $4,000 U Prepare a flexible budget analysis and explain whether you believe that costs were controlled.  How do the results of...
Item 1In the case below, the original source material is given alongwith a sample...
Item 1In the case below, the original source material is given along with a sample of student work. Determine the type of plagiarism by clicking the appropriate radio button.Original Source MaterialStudent VersionAPT was compared with numerous extant methodologies, including the linear models approach and event history analysis. The fundamental difference between APT and these other approaches is that no particular mathematical model is assumed in APT. In APT a model is viewed simply as a temporal pattern, whereas in most...
Item 6 In the case below, the original source material is given along with a sample...
Item 6 In the case below, the original source material is given along with a sample of student work. Determine the type of plagiarism by clicking the appropriate radio button. Original Source Material Student Version The study of learning derives from essentially two sources. Because learning involves the acquisition of knowledge, the first concerns the nature of knowledge and how we come to know things.... The second source in which modern learning theory is rooted concerns the nature and representation...
Item 6 In the case below, the original source material is given along with a sample...
Item 6 In the case below, the original source material is given along with a sample of student work. Determine the type of plagiarism by clicking the appropriate radio button. Original Source Material Student Version (written in 2002) Merck, in fact, epitomizes the ideological nature--the pragmatic idealism--of highly visionary companies. Our research showed that a fundamental element in the "ticking clock" of a visionary company is a core ideology--core values and a sense of purpose beyond just making money--that guides...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT