Determine the forecast for period 30 based on the 2-period

Assignment Help Other Subject

Reference no: EM132408800

Answer the Following Questions:

1. Determine the forecast for Period 30 based on the 2-period simple moving average.

2. Determine the forecast for Period 30 based on the 3-period simple moving average.

3. Determine the forecast for Period 30 based on the 8-period simple moving average.

4. Determine the 3 forecasts for Period 30 based on an exponential forecast model using smoothing constants of 0.25, 0.60, and 0.85.

5. Compute the MSE for each of the above forecasts based on periods 10 through 29 inclusive.

Details

The company financial controller suggested discontinuation of manufacturing and selling Cluster and Whole products. The product manager and others have differing opionions.

Develop an optimal LP production model for the company, analyze the model and the implication of your results, then revisit the controller's suggestion.

The model should optimize the total contribution margin for the company by determining the target production mix.

Use the attached workbook:

(1) Develop the model on the "Model Template" worksheet.

(2) Document your formulation by listing the objective function and constraint equations on the "Formulation Equations" worksheet.

(3) Update relevant portions of the prior period's "FIN ACCTG" information in "Pro Forma Adjustment" worksheet to reflect the next period based in info provided. When complete, run all 3 SOLVER reports in the workbook and be prepared to answer the questions below.
1. The optimal production mix.

2. Uniqueness of the solution.

3. Candidate product(s) to reduce or eliminate from the mix.

4. The marginal value of such action.

5. Where additional resources should be allocated and why.

6. The marginal value of those resources.

7. P&L associated with capital equipment additions.

8. The original return-on-sales (ROS) and the new ROS after optimization. [ROS=Total Net Income Before Interest and Taxes/Total Revenues]

9. The impact of pre-ordered products on the P&L.

10. Requirements for variables to enter the basis and required actions by the product manager.

11. The value of resources in the optimized model w.r.t. marginal values.

12. Impact of various actions on the contribution margins.

13. Net Profits by product lines of the optimzed model.

14. Candidate excess resources to transfer to other projects or product lines.

15. Optimistic forfecasts as the upper limit of sales.

16. Other questions related to the model results, its interpretation, AND management decisions.

Attachment:- Assignment-Small Business.rar

Reference no: EM132408800

Questions Cloud

Immigration and border security : Putting politics aside, how should the United States best address immigration now? What about in the next five years? What about the next ten years?

Become a currency of international exchange : Will Chinese yuan gain the status of the dollar or euro and become a currency of international exchange? Express your personal opinion on this.

Sell unusual fishing rods and other fishing equipment : Sam, Mark and Willy have decided to open a sporting goods store in Frederick, Maryland to sell unusual fishing rods and other fishing equipment.

Loss of confidence in international investors : Why do we not see a drastic fall in the value of the currency or any loss of confidence in international investors in the US financial market?

Determine the forecast for period 30 based on the 2-period : Determine the forecast for Period 30 based on the 2-period simple moving average. Compute the MSE for each of the above forecasts based on periods 10 through 29

Required return on king farm manufacturingcommon stock : If the risk-free rate is 3.32 percent, and the market return is 6.43 percent, calculate the required return on King Farm Manufacturing's common stock.

David meets goliath-negotiating with wal-mart : Consider a situation where you are negotiating with Wal-Mart for your family farm's milk. Confronted with various hardball price challenges

Calculate the jacksonn net cash flow : The Jacksons have presented their financial planner with the following information in order to prepare their statement of cash flows:

Financial planner with the information : 1. Mr. and Mrs. Claiborne, both age 40, have provided their financial planner with the following information:

User Account

All Pages