Production; purchases; cash budgets The December 31, 2013, balance sheet reveale

Question

Production; purchases; cash budgets

The December 31, 2013, balance sheet revealed the following selected account balances: Cash, $18,320; Direct Material Inventory, $8,230; Finished Goods Inventory, $23,200; and Accounts Payable, $5,800. The Direct Material Inventory balance represents 1,580 pounds of scrap iron and 1,200 bookstand bases. The Finished Goods Inventory consists of 1,220 bookstands.

    Each bookstand requires two pounds of scrap iron, which costs $3 per pound. Bookstand bases are purchased from a local lumber mill at a cost of $2.50 per unit. Company management decided that, beginning in 2014, the ending balance of Direct Material Inventory should be 25 percent of the following month’s production requirements and that the ending balance of Finished Goods Inventory should be 20 percent of the next month’s sales. Sales for April and May are expected to be 8,000 bookstands per month.

    The company normally pays for 75 percent of a month’s purchases of direct material in the month of purchase (on which it takes a 1 percent cash discount). The remaining 25 percent is paid in full in the month following the month of purchase.

    Direct labor is budgeted at $0.70 per bookstand produced and is paid in the month of production. Total cash manufacturing overhead is budgeted at $14,000 per month plus $1.30 per bookstand. Total cash selling and administrative costs equal $13,600 per month plus 10 percent of sales revenue. These costs are all paid in the month of incurrence. In addition, the company plans to pay executive bonuses of $35,000 in January 2014 and make an estimated quarterly tax payment of $5,000 in March 2014.

    Management requires a minimum cash balance of $10,000 at the end of each month. If the company borrows funds, it will do so only in $1,000 multiples at the beginning of a month at a 12 percent annual interest rate. Loans are to be repaid at the end of a month in multiples of $1,000. Interest is paid only when a repayment is made. Investments are made in $1,000 multiples at the end of a month, and the return on investment is 8 percent per year.

Explanation / Answer

a. Production Budget for 1st quarter 2014 Jan Feb March Total Sales 6,400 5,200 7,400 19,000 Add: Ending Inventory (20 percent of the next month’s sale) 1,040 1,480 1,600 1,600 Less: Beginning Inventory -1,220 -1,040 -1,480 -1,220 Production units 6,220 5,640 7,520 19,380 b) Direct Material Purchases Budget Scrap Iron Jan Feb March Total Production units 6,220 5,640 7,520 19,380 Pounds per unit 2 2 2 2 Production Needed 12,440 11,280 15,040 38,760 Ending Inventory 25 percent of the following month’s production requirements 2,820 3,760 4000 4000 Less: Beginning Inventory -1580 -2820 -3760 -1580 Purchases 13680 12220 15280 41180 Cost of Material $3 $3 $3 $3 Material purchased (a) $41,040 $36,660 $45,840 $123,540 Ending inventory = 25% of the next month’s production requirement January = 25% x 11280 2,820 February = 25% x 15040 3,760 March = 25% ×(8,000 + 1,600 – 1,600) = 25% × 8,000 = 2,000 ×2 lbs. = 4000 Bases Jan Feb March Total Production units 6,220 5,640 7,520 19,380 Ending inventory 1,410 1,880 2000 2000 Less: Beginning Inventory -1200 -1410 -1880 -1200 Purchases (bases) 6,430 6,110 7,640 20,180 Cost per base $2.5 $2.5 $2.5 $2.5 Purchases (bases) (b) $16,075 $15,275 $19,100 $50,450 Total purchases (a + b) $57,115 $51,935 $64,940 $173,990 Ending inventory = 25% of the next month’s production requirements January = 25% x 5640 1,410 February = 25% × 7,520 1,880 March = 25% ×(8,000 + 1,600 – 1,600) = 25% × 8,000 2000

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.