Cash budget. (Continuation of 6-44) (Appendix) Refer to the information in Problem 6-44. All purchases made in a given month are paid for in the following month, and direct material purchases make up all of the accounts payable balance and are reflected in the accounts payable balances at the beginning and the end of the year. Sales are made to customers with terms net 45 days. Fifty percent of a month’s sales are collected in the month of the sale, 25% are collected in the month following the sale, and 25% are collected two months after the sale and are reflected in the accounts receivables balances at the beginning and the end of the year. Direct manufacturing labor, variable manufacturing overhead and variable marketing costs are paid as they are incurred. Fifty percent of fixed manufacturing overhead costs, 60% of fixed marketing costs, and 100% of fixed distribution costs are depreciation expenses. The remaining fixed manufacturing overhead and marketing costs are paid as they are incurred. Selected balances for December 31, 2017, follow:
Hazlett has budgeted to purchase equipment costing $145,000 for cash during 2018. Hazlett desires a minimum cash balance of $25,000. The company has a line of credit from which it may borrow in increments of $1,000 at an interest rate of 12% per year. By special arrangement, with the bank, Hazlett pays interest when repaying the principal, which only needs to be repaid in 2019.
1. Prepare a cash budget for 2018. If Hazlett must borrow cash to meet its desired ending cash balance, show the amount that must be borrowed.
2. Does the cash budget for 2018 give Hazlett’s managers all of the information necessary to manage cash in 2018? How might that be improved?
3. What insight does the cash budget give to Hazlett’s managers that the budgeted income statement does not?
Comprehensive problem; ABC manufacturing, two products. Hazlett, Inc., operates at capacity and makes plastic combs and hairbrushes. Although the combs and brushes are a matching set, they are sold individually and so the sales mix is not 1:1. Hazlett’s management is planning its annual budget for fiscal year 2018. Here is information for 2018:
Inventory Information, Direct Materials
Hazlett accounts for direct materials using a FIFO cost flow.
Sales and Inventory Information, Finished Goods
Hazlett uses a FIFO cost-flow assumption for finished-goods inventory. Combs are manufactured in batches of 200, and brushes are manufactured in batches of 100. It takes 20 minutes to set up for a batch of combs and 1 hour to set up for a batch of brushes. Hazlett uses activity-based costing and has classified all overhead costs as shown in the following table. Budgeted fixed overhead costs vary with capacity. Hazlett operates at capacity so budgeted fixed overhead cost per unit equals the budgeted fixed overhead costs divided by the budgeted quantities of the cost allocation base.
Delivery trucks transport units sold in delivery sizes of 1,000 combs or 1,000 brushes. Do the following for the year 2018:
1. Prepare the revenues budget.
2. Use the revenues budget to:
a. Find the budgeted allocation rate for marketing costs.
b. Find the budgeted number of deliveries and allocation rate for distribution costs.
3. Prepare the production budget in units.
4. Use the production budget to:
a. Find the budgeted number of setups and setup-hours and the allocation rate for setup costs.
b. Find the budgeted total machine-hours and the allocation rate for processing costs. c. Find the budgeted total units produced and the allocation rate for inspection costs.
5. Prepare the direct material usage budget and the direct material purchases budget in both units and dollars; round to whole dollars.
6. Use the direct material usage budget to find the budgeted allocation rate for materials-handling costs. 7. Prepare the direct manufacturing labor cost budget.
8. Prepare the manufacturing overhead cost budget for materials handling, setup, processing, and inspection costs.
9. Prepare the budgeted unit cost of ending finished-goods inventory and ending inventories budget.
10. Prepare the cost of goods sold budget.
11. Prepare the nonmanufacturing overhead costs budget for marketing and distribution.
12. Prepare a budgeted income statement (ignore income taxes).
13. How does preparing the budget help Hazlett’s management team better manage the company?
Submit Your Assignment and get professional help from our qualified experts!
Cash budget. (Continuation of 6-44) (Appendix) Refer to the information in Problem 6-44. All… 1 answer below » was first posted on July 6, 2020 at 1:32 am.
©2019 "Submit Your Assignment". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at email@example.com