Accounting 221 Homework 2-8
Problem 1
| Each of the following ten statements includes a pair of words within parenthesis. Indicate which of the words should be chosen to make the statement true. The first statement is done as an example. | |
| 1. | A ( loan application / budget ) is a detailed financial plan that quantifies future expectations and actions relative to acquiring and using resources. |
| 2. | Budgets ( should / should not ) be used to provide managers with "preapproval" for execution of spending plans. |
| 3. | The ( master budget / sales budget ) is a comprehensive document specifying sales targets, production activities, and financing actions. |
| 4. | "Responsibility accounting" is a concept under which managers are held accountable for transactions and events ( beyond / under ) their direct influence and control. |
| 5. | Some entities will follow a top-down ( mandated / participative ) approach to budgeting. |
| 6. | A deliberate effort to create "breathing room" within a budget is known as ("padding the budget" / "aerating" ). |
| 7. | With ( incremental budgeting / zero-based budgeting ), each expenditure item must be justified for the new budget period. |
| 8. | The starting point for the master budget is an assessment of anticipated ( sales / production ). |
| 9. | This comes before the other: ( production budget / materials purchases budget ). |
| 10. | A ( static budget / flexible budget ) is not designed to change with changes in activity level. |
&L&"Arial,Bold"&12 &R&"Myriad Web Pro,Bold"&20B-21.01
B-21.01
Worksheet 1
| Each of the following statements includes a pair of words within parenthesis. Indicate which of the words should be chosen to make the statement true. The first statement is done as an example. | ||
| 1. | A ( loan application / budget ) is a detailed financial plan that quantifies future expectations and actions relative to acquiring and using resources. | |
| 2. | Budgets ( should / should not ) be used to provide managers with "preapproval" for execution of spending plans. | |
| 3. | The ( master budget / sales budget ) is a comprehensive document specifying sales targets, production activities, and financing actions. | |
| 4. | "Responsibility accounting" is a concept under which managers are held accountable for transactions and events ( beyond / under ) their direct influence and control. | |
| 5. | Some entities will follow a top-down ( mandated / participative ) approach to budgeting. | |
| 6. | A deliberate effort to create "breathing room" within a budget is known as ("padding the budget" / "aerating" ). | |
| 7. | With ( incremental budgeting / zero-based budgeting ), each expenditure item must be justified for the new budget period. | |
| 8. | The starting point for the master budget is an assessment of anticipated ( sales / production ). | |
| 9. | This comes before the other: ( production budget / materials purchases budget ). | |
| 10. | A ( static budget / flexible budget ) is not designed to change with changes in activity level. |
&L&"Myriad Web Pro,Bold"&12Name:
Date: Section: &R&"Myriad Web Pro,Bold"&20B-21.01
B-21.01
Problem 2
| Logan Township acquired its water system from a private company on June 1. No receivables were acquired with the purchase. Therefore, total accounts receivable on June 1 had a zero balance. Logan plans to bill customers in the month following the month of sale, and 70% of the resulting billings will be collected during the billing month. In the next following month, 90% of the remaining balance should be collectable. The remaining uncollectible amounts will relate to citizens who have moved away. Such amounts are never expected to be collected and will be written off. Water sales during June are estimated at $3,000,000, and expected to increase 30% in July. August sales will be 10% less than July sales. | |
| (a) | For each dollar of sales, how much is expected to be collected? |
| (b) | Estimate the monthly cash collections for June, July, August, and September. |
&L&"Arial,Bold"&12 &R&"Myriad Web Pro,Bold"&20B-21.02
B-21.02
Worksheet 2
| (a) | |||||||
| (b) | June | July | August | September |
&L&"Myriad Web Pro,Bold"&12Name:
Date: Section: &R&"Myriad Web Pro,Bold"&20B-21.02
B-21.02
Problem 3
| Blueline Printing's board of directors was presented with the following information about operations for an upcoming three-month period. The board desires to declare a dividend at the end of June, but still maintain cash on hand of $250,000. Blueline began April with $75,000 of cash on hand. Prepare a cash budget, and determine how much cash will be available for the dividend. Is there any apparent risk associated with the dividend plan? | ||||||
| April | May | June | ||||
| Customer receipts | $ 700,000 | $ 750,000 | $ 800,000 | |||
| Cash paid for direct materials | 200,000 | 222,000 | 265,000 | |||
| Cash paid for direct labor | 245,000 | 265,000 | 300,000 | |||
| Factory overhead* | 140,000 | 145,000 | 154,000 | |||
| SG&A** | 86,000 | 89,000 | 83,000 | |||
| Taxes | 15,000 | 18,000 | 16,000 | |||
| Equipment purchase*** | 500,000 | |||||
| * | Includes monthly depreciation of $100,000 | |||||
| ** | Includes monthly depreciation of $25,000 | |||||
| *** | Equipment purchase to be paid for in July |
&L&"Arial,Bold"&12 &R&"Myriad Web Pro,Bold"&20B-21.09
B-21.09
Worksheet 3
| April | May | June | |||
| Beginning cash balance | $ 75,000 | ||||
| Customer receipts | 700,000 | ||||
| Available cash | $ 775,000 | $ - | |||
| Less disbursements: | |||||
| $ - | |||||
| Ending cash balance | $ - |
&L&"Myriad Web Pro,Bold"&12Name:
Date: Section: &R&"Myriad Web Pro,Bold"&20B-21.09
B-21.09
Problem 4
| University Inn's most recent monthly expense analysis report revealed significant cost overruns. The manager was asked to explain the deviations. Below is the "budget v. actual" expense report for the month in question. | ||||||
| University Inn Budget v. Actual Expense Report For the Month Ending October 31, 20X7 | ||||||
| Actual | Budget | Variance | ||||
| Utilities | $ 52,000 | $ 45,000 | $ (7,000) | |||
| Laundry | 20,000 | 18,000 | (2,000) | |||
| Food service | 41,000 | 35,000 | (6,000) | |||
| Rent/taxes | 60,000 | 60,000 | - | |||
| Staff wages | 57,000 | 55,000 | (2,000) | |||
| Management salaries | 43,500 | 45,000 | 1,500 | |||
| Water | 13,000 | 10,000 | (3,000) | |||
| Maintenance | 15,200 | 15,000 | (200) | |||
| $ 301,700 | $ 283,000 | $ (18,700) | ||||
| The Inn has observed that utilities, water, food service, staff wages, and laundry costs all vary with activity. The other costs are fixed. The preceding budget was based upon an assumed 80% occupancy rate. The university's football team was on a winning streak and numerous alumni were returning to campus in October, resulting in a 96% occupancy rate during the month. | ||||||
| Prepare a "flexible budget" based upon a 96% occupancy rate, and identify whether the Inn is being efficiently or inefficiently run. Comment on specific costs, and note why a flexible budget can improve performance evaluations. |
&L&"Arial,Bold"&12 &R&"Myriad Web Pro,Bold"&20B-22.04
B-22.04
Worksheet 4
| University Inn Flexible Budget v. Actual Expense Report For the Month Ending October 31, 20X7 | ||||||
| Actual | Budget | Variance | ||||
| Utilities | $ 52,000 | $ - | $ - | |||
| Laundry | 20,000 | - | - | |||
| Food service | 41,000 | - | - | |||
| Rent/taxes | 60,000 | - | - | |||
| Staff wages | 57,000 | - | - | |||
| Management salaries | 43,500 | - | - | |||
| Water | 13,000 | - | - | |||
| Maintenance | 15,200 | - | - | |||
| $ 301,700 | $ - | $ - |
&L&"Myriad Web Pro,Bold"&12Name:
Date: Section: &R&"Myriad Web Pro,Bold"&20B-22.04
B-22.04