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 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. 3. Use the results of #2 and #3 to prepare a budgeted contribution margin income statement for 10,000 units. 4. Compute contribution margin ratio. 5. How many units does company need to sell to break even? What is the break-even in sales dollars. 6. Prepare a break-even graph. 7. How many units would have to be sold to achieve an operating income of $20,000? 8. Compute the margin of safety at 10,000 units. 9. If sales volumes increase 20% (from 10,000 units), what is the percentage and dollar amount of increase in profit (use operating leverage to determine). 10. It is projected an increase of $3,000 in advertising costs will lead to the sale of 200 additional units. Should the company do this? Show computations. 11. Lasko Industries has offered the company $48 for 500 units one month. If the company accepts this offer, it will not have to pay sales commissions. The company's capacity is 12,000 units each month, so it will not have to add an additional shift a. Should the company accept the offer? Provide computations. b. What are some of the qualitative issues management should consider in making this decision? 12. Classify costs as product or period costs and determine the manufacturing cost per unit. F. Monthly budget for 10,000 units. Factory utility costs for the prior year $ 30,000 15,000 100,000 Machine hours 4,240 cost 3,350 January $ 3,500 4,200 4,150 Administrative Salaries Advertising Assembly labor Building rent and janitorial costs (80% related to factory) Equipment depreciation Factory supplies Factory utilities (requirement 1) Insurance (60% related to factory) Machine Maintenance Material Office supplies Office utilities Sales Commissions Sales Salaries Supervisors Telephone and internet 20,000 18,000 4,500 ??? 8,000 16,100 335,000 2,400 1,200 18,600 20,000 12,000 1,500 February March April May June July August September October November December 4,310 5,630 5,260 4,910 4,790 5,120 5,380 4,830 5,470 5,180 4,430 3,700 4,250 4,300 3,750 4,350 4,100 3,650 602,300 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 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. 3. Use the results of #2 and #3 to prepare a budgeted contribution margin income statement for 10,000 units. 4. Compute contribution margin ratio. 5. How many units does company need to sell to break even? What is the break-even in sales dollars. 6. Prepare a break-even graph. 7. How many units would have to be sold to achieve an operating income of $20,000? 8. Compute the margin of safety at 10,000 units. 9. If sales volumes increase 20% (from 10,000 units), what is the percentage and dollar amount of increase in profit (use operating leverage to determine). 10. It is projected an increase of $3,000 in advertising costs will lead to the sale of 200 additional units. Should the company do this? Show computations. 11. Lasko Industries has offered the company $48 for 500 units one month. If the company accepts this offer, it will not have to pay sales commissions. The company's capacity is 12,000 units each month, so it will not have to add an additional shift a. Should the company accept the offer? Provide computations. b. What are some of the qualitative issues management should consider in making this decision? 12. Classify costs as product or period costs and determine the manufacturing cost per unit. F. Monthly budget for 10,000 units. Factory utility costs for the prior year $ 30,000 15,000 100,000 Machine hours 4,240 cost 3,350 January $ 3,500 4,200 4,150 Administrative Salaries Advertising Assembly labor Building rent and janitorial costs (80% related to factory) Equipment depreciation Factory supplies Factory utilities (requirement 1) Insurance (60% related to factory) Machine Maintenance Material Office supplies Office utilities Sales Commissions Sales Salaries Supervisors Telephone and internet 20,000 18,000 4,500 ??? 8,000 16,100 335,000 2,400 1,200 18,600 20,000 12,000 1,500 February March April May June July August September October November December 4,310 5,630 5,260 4,910 4,790 5,120 5,380 4,830 5,470 5,180 4,430 3,700 4,250 4,300 3,750 4,350 4,100 3,650 602,300