HoDown Hats makes felt cowboy hats with leather trim that sell for $70 each. Each hat requires
Question:
Another company policy is to have a monthly ï¬nished goods ending inventory of 25 percent of the next months sales.
During the ï¬rst quarter of 2010, management expects no work in process inventories at the beginning or ending of any month. Additionally, the company expects Aprils production of hats to be exactly equal to its sales volume for that month. Sales for the ï¬rst four months of 2010 follow.
The company collects 35 percent of its Accounts Receivable in the month of sale and the remainder in the month following the sale. There are no uncollectible accounts.
The December 31, 2009, balance sheet revealed the following selected balances: Cash, $3,500; Accounts Receivable, $162,500; Raw Material Inventory (450 yards of felt and 305 yards of leather), $5,925; Finished Goods Inventory (3,200 hats), $80,800; and Accounts Payable, $31,500.
The company pays for 30 percent of a months purchases of raw material in the month of purchase (rounded to the nearest dollar). The remaining amount is paid in the month after purchase.
Direct labor cost per hat is $9 per hat produced and is paid in the month of production. Total factory overhead is $18,000 per month plus $2.50 per hat produced; of that amount, $3,000 per month is for depreciation. Total non factory cash costs are equal to $32,800 per month plus 10 percent of sales revenue. All factory and non-factory cash expenses are paid in the month of incurrence. In addition, the company plans to make an estimated quarterly tax payment of $245,000 and pay executive bonuses of $435,000 in March 2010.
Required:
(a) Prepare a sales budget by month and in total for the ï¬rst quarter of 2010.
(b) Prepare a schedule of cash collections from customers by month and in total for the ï¬rst quarter of 2010. The Accounts Receivable balance on December 31, 2009, represents the unpaid amount of December sales.
(c) What were total sales for December 2009? What is the April 1, 2010, balance of Accounts Receivable?
(d) Prepare a production budget by month and in total for the ï¬rst quarter of 2010.
(e) Prepare purchases budgets for felt and leather by month and in total for the ï¬rst quarter of 2010.
(f) Prepare a schedule of cash payments for purchases by month and in total for the ï¬rst quarter of 2010. The Accounts Payable balance on December 31, 2009, represents the unpaid amount of December purchases.
(g) What were total raw material purchases for December 2009? What is the April 1, 2010, balance of Accounts Payable?
(h) Prepare a combined payments schedule for factory overhead and nonfactory cash costs for each month and in total for the ï¬rst quarter of 2010.
(i) Prepare a cash budget for each month and in total for the ï¬rst quarter of 2010.
(j) What is the standard cost per cowboy hat? (Hint: Review the beginning balance information.) How was this cost calculated? Given the cost per hat for ï¬xed production overhead, what is the expected quantity of production each month?
The ending inventory is the amount of inventory that a business is required to present on its balance sheet. It can be calculated using the ending inventory formula Ending Inventory Formula =... Accounts Payable
Accounts payable (AP) are bills to be paid as part of the normal course of business.This is a standard accounting term, one of the most common liabilities, which normally appears in the balance sheet listing of liabilities. Businesses receive... Accounts Receivable
Accounts receivables are debts owed to your company, usually from sales on credit. Accounts receivable is business asset, the sum of the money owed to you by customers who haven’t paid.The standard procedure in business-to-business sales is that... Balance Sheet
Balance sheet is a statement of the financial position of a business that list all the assets, liabilities, and owner’s equity and shareholder’s equity at a particular point of time. A balance sheet is also called as a “statement of financial... Cash Budget
A cash budget is an estimation of the cash flows for a business over a specific period of time. These cash inflows and outflows include revenues collected, expenses paid, and loans receipts and payment. Its primary purpose is to provide the...
Step by Step Answer: