Managerial Accounting

Hi CH Tutor! Please help me to answer these questions on Microsoft Excel. We need the one-by-one solution for these. If you follow the instructions, I will give you positive feedback. Thank you.

1. Determine the Variable cost rate per repairs.

2. Fixed costs per month

Using the leastsquare method. determine the following: Baichu Vehicle Repair Center shows the number of repairs taken and costs over the last six months are given below: Month Repairs Repair Casts . Month Repairs Repair Casts _ Taken . Taken _ January . 800 . P2?0.000.00 April . 400 P 190,000.00 _ February 500 : 200000.00 : Ma).r 600 . 240.000.00 March . 1.000 ; 310,000.00 June 900 290,000.00