Customer Question
DATA: Carewood makes an environmentally friendly artificial fireplace log. You have been asked to prepare the company's master budget for the first quarter of the year 2008 and have been provided with the following:
a.The 12/31/2007 balance sheet data follows:
ASSETS
Cash $ 4,330
Accounts Receivable8,450
Direct Materials Inventory (2,178 pounds)436
Finished Goods Inventory (1,200 logs) 2,808
Plant and Equipment$220,000
Less Accumulated Depreciation (56,000) 164,000
Total Assets&nbs p;$180,024
LIABILITIES AND STOCKHOLDER'S EQUITY
Accounts Payable&nb sp;$ 1,109
Note Payable&nb sp; 20,000
Total Liabilities ; $ 21,109
Common Stock $100,000
Retained Earnings 58,915 158,915
Total Liabilities and Stockholder's Equity$180,024
b.Each log requires the following standards for direct material and labor:
%u20223.3 pounds of material mix at $.20 per lb
%u202210 minutes of labor time per unit; direct labor
averages $14.40 per hour
Each finished log requires three minutes of machine time. Variable overhead is applied at the rate of $12.00 per hour of machine time. Annual fixed production overhead is budgeted at $46,800 (see breakdown below).
Salaries&n bsp; $30,000
Insurance& nbsp; 1,800
Fixed portion of utilities6,000
Depreciation&nbs p;9,000
Total ;$46,800
Fixed overhead is incurred evenly throughout the year
c.Expected sales in units for the first five months of 2008 are:
January&nb sp;6,000
February&n bsp;9,000
March ;6,500
April ;5,900
May& nbsp;5,100
Carewood grants no discounts, and all sales are on credit at $6.00 per log. The company's collection pattern is 80 percent in the month of sale, 15 percent in the month following sale, and 5 percent in the second month following the sale. The Accounts Receivable balance in the balance sheet data represents amounts remaining due from November sales of $33,000 and December sales of $34,000.
d.Carewood completes all production each day. The desired ending balance of Direct Materials Inventory is 10 percent of the amount needed to satisfy the next month's production for finished goods. The desired ending balance in Finished Goods Inventory is 20 percent of the next month's sales.
e.Purchases of direct materials are paid 70 percent in the month of purchase and 30 percent in the month following the purchase. No discounts are taken. The note payable has a 12 percent interest rate, and the interest is paid at the end of each month. The $20,000 balance of the principal on the note is due on March 31, 2008.
f.CareWood's minimum cash balance desired is $4,000. The firm may borrow at the beginning of a month anrepay at the end of the month in $500 increments. ($500,$1000,$1500etc) Interest on these short-term loans, if any, is payable monthly at a 14% rate. you may have to borrow money to meet your monthly intereat obligations on any loans outstanding.
g.Selling and Administrative expenses, paid as incurred, run $9,000 per month plus 1 percent of sales. Direct labor and overhead are paid as incurred.
h.The company accrues income taxes at a 40 percent rate. A quarterly tax installment will be paid on April 15, 2008.
REQUIRED:
1.Prepare a sales budget in units and dollars for the first quarter of 2008 (January, February, March)
2.Prepare a schedule of expected cash collections from Customers for the first quarter of 2008
3.Prepare a production budget for the first quarter of 2008.
4.Prepare a direct materials purchases budget for the first quarter of 2008.
5.Prepare a schedule of cash payments for direct materials for the first quarter of 2008.
6.Prepare a budgeted schedule of cost of goods manufactured for the first quarter
7.Prepare a budgeted Income Statement for the first quarter of 2008
8.Prepare a cash budget for the first quarter of 2008.
9.Essay: What types of information do your budgets yield? Is cash flow adequate? Do sales need to be increased, costs reduced?