Question
1. Badlands, Inc. manufactures a household fan that sells for $40 per unit. All sales are on account, with 35 percent of sales collected in
1.
Badlands, Inc. manufactures a household fan that sells for $40 per unit. All sales are on account, with 35 percent of sales collected in the month of sale and 65 percent collected in the following month. The data that follow were extracted from the companys accounting records.
- Badlands maintains a minimum cash balance of $21,000. Total payments in January 20x1 are budgeted at $225,000.
- A schedule of cash collections for January and February of 20x1 revealed the following receipts for the period:
Cash Receipts January February From December 31 accounts receivable $ 130,000 From January sales 88,000 $ 160,000 From February sales 74,900
- March 20x1 sales are expected to total 6,000 units.
- Finished-goods inventories are maintained at 20 percent of the following months sales.
- The December 31, 20x0, balance sheet revealed the following selected figures: cash, $23,700; accounts receivable, $130,000; and finished goods, $24,150.
Required:
-
Determine the number of units that Badlands sold in December 20x0.
-
Compute the sales revenue for March 20x1.
-
Compute the total sales revenue to be reported on Badlands budgeted income statement for the first quarter of 20x1.
-
Determine the accounts receivable balance to be reported on the March 31, 20x1, budgeted balance sheet.
-
Calculate the number of units in the December 31, 20x0, finished-goods inventory.
-
Calculate the number of units of finished goods to be manufactured in January 20x1.
-
Calculate the financing required in January, if any, to maintain the firms minimum cash balance.
2.
Scholastic Furniture, Inc. manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the companys Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the divisions sales manager.
April | 10,000 | desk-and-chair sets |
May | 12,000 | desk-and-chair sets |
June | 15,000 | desk-and-chair sets |
Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of direct labor. Each set sells for $50. Pine planks cost $.50 per board foot, and the division ends each month with enough wood to cover 10 percent of the next months production requirements. The division incurs a cost of $20 per hour for direct-labor wages and fringe benefits. The division ends each month with enough finished-goods inventory to cover 20 percent of the next months sales.
Required:
Complete the following budget schedules.
-
Sales budget.
-
Production budget (in sets).
-
Raw-material purchases.
-
Direct-labor budget.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started