PLEASE DO IT HANDWRITTEN IN A PAPER.WILL THUMBS UP (THANK YOU) :)

MBA Assignment The Roasted Chicken House Restaurant has provided you with the following information on its costs at various levels of monthly sales. Monthly sales units Cost of food Supplies Other operating costs Utilities Building rent Depreciation Total cost 400 9,000 400 2,000 500 2,000 200 14,100 800 10,000 800 4,000 900 2,000 200 17,900 1,200 17,000 1,200 6,000 1300 2,000 200 27,700 Required 1. Draw scatter graph for each cost items and explain cost behaviour. 2. Identify each cost as variable, fixed or semi-variable (mixed) cost with reasons. 3. Segregate semi-variable cost, if any, using high-low method and develops an equation for each cost items. 4. Segregate semi-variable cost, if any, using least square method and develops an equation for each cost items. 5. Predict total cost for monthly budgeted outputs for 1,000 units as per results of (3) above. 6. Predict total cost for monthly budgeted outputs for 1,000 units as per results of (4) above. 7. Compare results of above (5) and (6), and draw conclusion about reliability of these two results with valid reasons