ACC 205 Mini Case 1 Case Description Jasper Company produces widgets that it sells for $62 each, and Joe Jasper, the owner, is contemplating several ideas to grow his business. He has brought his monthly operating budget to you and has asked you to analyze it for him. (See BUDGET page in accompanying EXCEL spreadsheet.) Each unit requires 12 hour of machine time and direct labor. Assembly workers are paid $20 per hour. The machinery is serviced on a regular schedule based on the number of hours each machine runs. Case Problems Prepare a report that addresses the following questions. You can answer the questions in the way that you feel works best, but you must include answers to all 12 questions in your submission, and you must submit your Excel spreadsheet for this mini case (available in the course): 1. The factory utilities cost is a mixed cost. The utilities cost and number of machine hours are listed on the accompanying EXCEL spreadsheet on the tab "UTILITIES." Determine a cost equation for utilities using SLOPE and INTERCEPT functions in EXCEL - use it to determine budgeted utility costs for this month based on 10,000 units. (Round slope to nearest cent and intercept to nearest $10. 2. Classify the remaining costs as fixed or variable, and document your rationale.