complete the assigned problems in Microsoft Excel

Chapter 6 Activity Analysis. Cost Behavior, and Cost Estimation 271 (a) (e) (9) (i) ()) (k)Exercise 6-28 The lowa City Veterinary Laboratory performs a variety of diagnostic tests on commercial and domestic animals. The lab has incurred the following costs over the past year. Visual-Fit Method: Veterinary Laboratory Diagnostic Tests Month Completed Cost January 3 050 $61.000 February 4.500 74.500 March 7100 30 000 April 6.200 95 600 May 4 700 74 800 June 5.900 89 000 Juty 5.000 August 6.100 30 000 September 5.300 87 000 October 4.900 76.200 November 4.800 WE. 100 December 5,050 80 700 Required: 1. Plot the data above in a scatter diagram. Assign cost to the vertical axis and the number of dias- nostic tests to the horizontal axis. Visually fit a line to the plotted data. 2. Using the visually fit line, estimate the monthly fixed cost and the variable cost per diagnostic test.Problems All applicable Problems are available in Connect. connect Problem 6-35 For each of the cost items described below, choose the graph (see next page) that best represents it Cost Behavior Patterns in a Variety of Settings, Interna- 1. The salary costs of the shift supervisors at a truck depot. Each shift is eight hours. The depot oper- tional Issues ales with one. two. or three shifts at various times of the year. (LO 6-1, 6-2) 2. The salaries of the security personnel at a factory. The security guards are on duty around the clock. 3. The wages of table-service personnel in a restaurant. The employees are part-time workers, who can be called upon for as little as two hours at a time. 4. The cost of electricity during peak-demand periods is based on the following schedule. Up to 9.500 kilowatt-hours (awhy $ 10 per kwh Above 9,500 kilowatt-hours S. 13 per kurt The price schedule is designed to discourage overuse of electricity during periods of peak demand 5. The cost of sheet metal used to manufacture automobiles. 6. The cost of utilities at a university. For low student enrollments. utility costs increase with enrollment, but at a decreasing rate. For large student enrollments, utility costs increase at an increasing rate. 7. The cost of online back-up storage at a rate of $2.50 per gigabyte. up to 50 gigabytes, beyond which storage is unlimited, at no additional cost. 8. The cost of the nursing staff in a hospital. The staff always has a minimum of nine nurses on duty. Additional nurses are used depending on the number of patients in the hospital. The hospital administrator estimates that this additional nursing staff costs approximately $195 per patient per day. 9. The cost of chartering a private airplane. The cost is $390 per hour for the first three hours of a flight. Then the charge drops to $280 per hour. 10. Under a licensing agreement with a South American import/export company. your firm has begun shipping machine tools to several countries. The terms of the agreement call for an annual licens- ing fee of $100.000 to be paid to the South American import company if total exports are under $5,000,000. For sales in excess of $5.000.000, an additional licensing fee of 10 percent of sales is due. 11. Your winery exports wine to several Pacific Rim countries. In one nation, you must pay a tariff for every case of wine brought into the country. The tariff schedule is the following: O to 5,500 cases per year $12 per case 5,501 to 11,000 cases per year $15 per case Above 11,000 cases per year $20 per case