Caribbean Milken produces similar products in three plants located in different islands and has markets throughout Latin America and the Caribbean. It has built a new plant and expanded its market and now wishes to revise its shipping plan so as to minimize its overall shipping costs.
The shipping costs to ship these products from its three plants to its four markets are indicated in the Table below. Also indicated are the plant capacities and the market demand.
FROM TO CAPACITY
MARKET 1 MARKET 2 MARKET 3 MARKET 4
PLANT 1 $132 $116 $250 $110 220
PLANT 2 $220 $230 $180 $178 300
PLANT 3 $152 $173 $196 $164 435
DEMAND 160 120 200 230

I. Derive an initial solution that would result in a low cost shipping plan, using

Mop and Broom Manufacturing company has tracked the number of units sold of their most popular mop over the past 24 months. This is indicated in the table below:


Month Sales Month Sales Month Sales
1 239 9 310 17 369
2 248 10 335 18 378
3 256 11 348 19 367
4 260 12 353 20 383
5 271 13 355 21 394
6 280 14 368 22 393
7 295 15 379 23 405
8 305 16 358 24 412
1) Assuming a linear trend, use the tabular method to derive the values for :
a) the intercept and slope [13 marks]
2) Use the derived linear equation to:
a) plot the linear regression line , and [3 marks]
b) develop a forecast for months 25 and 30. [4 marks]
3) Use excel software to :
a) plot a graph with the raw data provided, and [4 marks]
b) draw the trend line [3 marks]
c) Illustrate the forecast for months 25 through 30, by extrapolation of the trend line. [2 marks]
4) Use a three-month moving average and a six-month moving average to develop forecasts for months 25 and 30. [6 marks]

Thank you for taking the time to copy your homework to AMHD.
Please refer to this announcement: CLICK HERE !! (https://www.askmehelpdesk.com/finance-accounting/announcement-font-color-ff0000-u-b-read-first-expectations-homework-help-board-b-u-font.html)