Lotus company incurred the following maintenance costs during the past 9 months: Table 1 Months Room...

Transcribed Image Text:

Lotus company incurred the following maintenance costs during the past 9 months: Table 1 Months Room occupancy 1 120 2 210 3 50 4 160 5 430 Cost $ 4560 9780 2920 8280 20320 6789 6 80 3920 325 17140 143 570 5500 22400 REQUIRED Part 1 A. Use the data on Table 1, estimate the variable and fixed cost of the company using the high and low method B. Develop a cost function for the company. C. Estimate the maintenance cost if 630 rooms are occupied in October Part 2 1. Use a scatter graph and the two points that seem to best represent the relationship between cost and activity levels of 80 and 325 machine hours. Use these two points, estimate the variable cost and the fixed cost [components of maintenance costs] 2. Develop a cost function that the company can use to estimate maintenance cost at different volume levels of occupancy 3. Estimate maintenance costs for December if the company expects 600 rooms to be occupied SHOULD CONSTRUCT THE GRAPH USING GRAPH PAPER [available free on internet]. Very little mark will be given if you make a sketch, Part 3 1. Using the least square formula find Fixed cost and Unit variable cost 2. State the cost function 3. If X = 800 what is Y Lotus company incurred the following maintenance costs during the past 9 months: Table 1 Months Room occupancy 1 120 2 210 3 50 4 160 5 430 Cost $ 4560 9780 2920 8280 20320 6789 6 80 3920 325 17140 143 570 5500 22400 REQUIRED Part 1 A. Use the data on Table 1, estimate the variable and fixed cost of the company using the high and low method B. Develop a cost function for the company. C. Estimate the maintenance cost if 630 rooms are occupied in October Part 2 1. Use a scatter graph and the two points that seem to best represent the relationship between cost and activity levels of 80 and 325 machine hours. Use these two points, estimate the variable cost and the fixed cost [components of maintenance costs] 2. Develop a cost function that the company can use to estimate maintenance cost at different volume levels of occupancy 3. Estimate maintenance costs for December if the company expects 600 rooms to be occupied SHOULD CONSTRUCT THE GRAPH USING GRAPH PAPER [available free on internet]. Very little mark will be given if you make a sketch, Part 3 1. Using the least square formula find Fixed cost and Unit variable cost 2. State the cost function 3. If X = 800 what is Y