Question: 2.2.3 The cost data for BC Billing Solutions for the year 2020 is as follows: Month January February March April May June July August September
2.2.3 The cost data for BC Billing Solutions for the year 2020 is as follows: Month January February March April May June July August September October November December Invoices Processed 12000 8000 1000 7000 5000 10000 11000 9000 5000 9000 8000 11000 Overtime Wages 5 7,760 5 6,800 $ 6,000 5 6.100 $ 6,200 5 7,300 $ 7.400 5 6.900 5 6.500 $ 6.600 5 6.800 $ 7,450 A. Using the high-low method, express the company's overtime wages as an equation where x represents number of invoices processed. Assume BC has monthly fixed costs of $3,800. B. Predict the overtime wages if 9,000 invoices are processed. C. Predict the overtime wages if 6,500 invoices are processed. D. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of invoices processed and overtime wage expense
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
