Chapter 22: 18RQ (page 1228)
What is the formula used to determine the amount of merchandise inventory to be purchased?
To calculate the amount of merchandise inventory purchase, you will need the value of beginning and closing inventory and the cost of goods sold.
Over 30 million students worldwide already upgrade their learning with Vaia!
All the tools & learning materials you need for study success - in one app.
Get started for free
What is sensitivity analysis? Why is it important for managers?
Preparing an operating budget—cost of goods sold budget Butler Company expects to sell 1,650 units in January and 1,550 units in February. The company expects to incur the following product costs:
Direct materials cost per unit \( 85
Direct labor cost per unit 60
Manufacturing overhead cost per unit 55
The beginning balance in Finished Goods Inventory is 250 units at \)200 each for a total of $50,000. Butler uses FIFO inventory costing method. Prepare the cost of goods sold budget for Butler for January and February.
Question: Preparing a financial budget—schedule of cash receipts, schedule cash payments, cash budget
Baxter Company’s budget committee provides the following information: December 31, 2017, account balances:
1. Prepare the schedule of cash receipts from customers for January and February 2018. Assume cash receipts are 80% in the month of the sale and 20% in the month following the sale.
2. Prepare the schedule of cash payments for purchases for January and February 2018. Assume purchases are paid 60% in the month of purchase and 40% in the month following the purchase.
3. Prepare the schedule of cash payments for selling and administrative expenses for January and February 2018. Assume 40% of the accrual for Salaries and Commissions Payable is for commissions and 60% is for salaries. The December 31 balance will be paid in January. Salaries and commissions are paid 30% in the month incurred and 70% in the following month. Rent and income tax expenses are paid as incurred. Insurance expense is an expiration of the prepaid amount.
4. Prepare the cash budget for January and February 2018. Assume no financing took place.
Preparing an operating budget—direct materials, direct labor, and manufacturing overhead budgets
Grady, Inc. manufactures model airplane kits and projects production at 650, 500, 450, and 600 kits for the next four quarters. Direct materials are 4 ounces of plastic per kit and the plastic costs \(1 per ounce. Indirect materials are considered insignificant and are not included in the budgeting process. Beginning Raw Materials Inventory is 850 ounces, and the company desires to end each quarter with 10% of the materials needed for the next quarter’s production. Grady desires a balance of 200 ounces in Raw Materials Inventory at the end of the fourth quarter. Each kit requires 0.10 hours of direct labor at an average cost of \)10 per hour. Manufacturing overhead is allocated using direct labor hours as the allocation base. Variable overhead is \(0.20 per kit, and fixed overhead is \)165 per quarter. Prepare Grady’s direct materials budget, direct labor budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for production, budgeted overhead costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number.
Preparing a financial budget—cash budget
Wilson Company has \(11,000 in cash on hand on January 1 and has collected the following budget data:
January February Sales \) 1,400,000 \( 710,000 Cash receipts from customers 851,420 871,800 Cash payments for merchandise inventory 561,100 532,310
Assume Wilson has cash payments for selling and administrative expenses including salaries of \)55,000 plus commissions of 2% of sales, all paid in the month of sale. The company requires a minimum cash balance of $8,500. Prepare a cash budget for January and February. Will Wilson need to borrow cash by the end of February?
What do you think about this solution?
We value your feedback to improve our textbook solutions.
