Borkenstick Makes a Very Popular Undyed - Asset Essay Example

Borkenstick makes a very popular undyed cloth sandal in one style, but in Regular and Deluxe - Borkenstick Makes a Very Popular Undyed introduction. The Regular sandals have cloth soles and the Deluxe sandals have cloth covered wooden soles. Borkenstick is preparing its budget for June 2012, and has estimated sales based on past experience. Other information for the month of June follows:

Borkenstick uses a FIFO cost flow assumption for finished goods inventory. All the sandals are made in batches of 50 pairs of sandals. Borkenstick incurs manufacturing overhead costs, marketing and general administration, and shipping costs. Besides materials and labor, manufacturing costs include setup, processing, and inspection costs. Borkenstick ships 40 pairs of sandals per shipment. Borkenstick uses activity-based costing and has classified all overhead costs for the month of June as shown in the following chart:

Need

essay sample on "Borkenstick Makes a Very Popular Undyed"

? We will write a cheap essay sample on "Borkenstick Makes a Very Popular Undyed" specifically for you for only $12.90/page

More Asset, Expense Essay Topics.

Required 1. Prepare each of the following for June: a. Revenues budget b. Production budget in units c. Direct material usage budget and direct material purchases budget in both units and dollars; round to dollars d. Direct manufacturing labor cost budget e. Manufacturing overhead cost budgets for processing and setup activities f. Budgeted unit cost of ending finished goods inventory and ending inventories budget g. Cost of goods sold budget h. Marketing and general administration costs budget 2. Borkenstick’s balance sheet for May 31 follows. Use it and the following information to prepare a cash budget for Borkenstick for June. Round to dollars. All sales are on account; 60% are collected in the month of the sale, 38% are collected the following month, and 2% are never collected and written off as bad debts. All purchases of materials are on account. Borkenstick pays for 80% of purchases in the month of purchase and 20% in the following month. All other costs are paid in the month incurred, including the declaration and payment of a $10,000 cash dividend in June. Borkenstick is making monthly interest payments of 0.5% (6% per year) on a $100,000 long term loan. Borkenstick plans to pay the $7,200 of taxes owed as of May 31 in the month of June. Income tax expense for June is zero. 30% of processing and setup costs, and 10% of marketing and general administration costs are depreciation.

3. Prepare a budgeted income statement for June and a budgeted balance sheet for Borkenstick as of June 30. SOLUTION: 1a. Revenues Budget For the Month of June, 2012 Units Selling Price Total Revenues 2,000 $80 $160,000 3,000 130 390,000 $550,000

Regular Deluxe Total

b. Production Budget For the Month of June, 2012

Budgeted unit sales Add: target ending finished goods inventory Total required units Deduct: beginning finished goods inventory Units of finished goods to be produced

Product Regular Deluxe 2,000 3,000 400 600 2,400 3,600 250 650 2,150 2,950

c. Direct Material Usage Budget in Quantity and Dollars For the Month of June, 2012 Material Cloth Wood Physical Units Budget Direct materials required for Regular (2,150 units × 1.3 yd.; 0 bd-ft) 2,795 yds. 0 Deluxe (2,950 units × 1.5 yds.; 2 bd-ft) 4,425 yds. 5,900 Total quantity of direct materials to be used 7,220 yds. 5,900 Cost Budget Available from beginning direct materials inventory (under a FIFO cost-flow assumption) $ 2,146 $ 4,040 To be purchased this period Cloth: (7220 yd. – 610 yd.) × $3.50 per yd. 23,135 Wood: (5,900 – 800) × $5 per bd-ft _ ___ 25,500 Direct materials to be used this period $25,281 $29,540

Total

$54,821

Direct Materials Purchases Budget For the Month of June, 2012 Material Cloth Wood Physical Units Budget To be used in production Add: Target ending direct material inventory Total requirements Deduct: beginning direct material inventory Purchases to be made Cost Budget Cloth: (6,996 yds. × $3.50 per yd.) Wood: (5,395 ft × $5 per bd-ft) Total 7,220 yds. 386 yds.
7,606 yds. 610 yds. 6,996 yds. $24,486 ___ _ $24,486 5,900 ft 295 ft 6,195 ft 800 ft 5,395 ft $26,975 $26,975

Total

$51,461

d. Direct Manufacturing Labor Costs Budget For the Month of June, 2012 Output Units Direct Manufacturing Total Hourly Wage Produced Labor-Hours per Unit Hours Rate Regular 2,150 5 10,750 $10 Deluxe 2,950 7 20,650 10 Total 31,400 e. Manufacturing Overhead Costs Budget For the Month of June 2012 Total Machine setup (Regular 43 batches1 2 hrs./batch + Deluxe 59 batches2 3 hrs./batch) $12/hour Processing (31,400 DMLH $1.20) Inspection (5100 pairs x $0.90 per pair) Total 1

Total $107,500 206,500 $314,000

$ 3,156 37,680 4,590 $45,426

Regular: 2,150 pairs ÷ 50 pairs per batch = 43; 2Giant: 2,950 pairs ÷ 50 pairs per batch = 59

f.
Unit Costs of Ending Finished Goods Inventory For the Month of June, 2012 Regular Cost per Input per T Cloth Wood Direct manufacturing labor Machine setup Processing Inspection Total 1

Deluxe Input per Unit of Output 1.5 yd 2 bd-ft 7 hrs 0.06 hr1 7 hrs 1 pair Total $ 5.25 10.00 70.00 0.72 8.40 0.90 $95.27

Unit of Input $ 3.50 5.00 10.00 12.00 1.20 0.90

Unit of Output 1.3 yd 0 5 hr. 0.04 hr. 1 5 hrs 1 pair

otal $ 4.55 0 50.00 0.48 6.00 0.90 $61.93

2 hours per setup ÷ 50 pairs per batch = 0.04 hr. per unit; 3 hours per setup ÷ 50 pairs per batch = 0.06 hr. per unit.

Ending Inventories Budget June, 2012 Quantity Cost per unit Direct Materials Cloth Wood Finished goods Regular Deluxe Total ending inventory g. Cost of Goods Sold Budget For the Month of June, 2012 Beginning finished goods inventory, June 1 ($15,500 + $61,750) Direct materials used (requirement c) Direct manufacturing labor (requirement d) Manufacturing overhead (requirement e) Cost of goods manufactured Cost of goods available for sale Deduct ending finished goods inventory, June 30 (requirement f) Cost of goods sold h. Nonmanufacturing Costs Budget For the Month of June, 2012 Total Marketing and general administration 8% 550,000 Shipping (5,000 pairs / 40 pairs per shipmt) x $10 Total 2. Cash Budget $44,000 1,250 $45,250 $ 77,250 $54,821 314,000 45,426 414,247 491,497 81,934 $409,563 400 600 $61.93 95.27 $24,772 57,162 81,934 $84,760 386 yards 295 bd-ft $3.50 5.00 $1,351 1,475 $ 2,826 Total

June 30, 2012 Cash balance, June 1 (from Balance Sheet) Add receipts Collections from May accounts receivable Collections from June accounts receivable ($550,000 60%) Total collection from customers Total cash available for needs (x) Deduct cash disbursements Direct material purchases in May Direct material purchases in June ($51,461 80%) Direct manufacturing labor Manufacturing overhead ( $45,426 70% because 30% is depreciation) Nonmanufacturing costs ( $45,250 90% because 10% is depreciation) Taxes Dividends Total disbursements (y) Financing Interest at 6% ($100,000 6% 1 ÷ 12) (z) Ending cash balance, June 30 (x) ─ (y) ─ (z)

$

6,290 205,200

330,000 535,200 $541,490 $ 10,400 41,169 314,000

31,798

40,725 7,200 10,000 $455,292 $ $ 500 85,698

3. Budgeted Income Statement For the Month of June, 2012 Revenues Cost of goods sold Gross margin Operating (nonmanufacturing) costs Bad debt expense ($550,000 2%) Interest expense (for June) Net income $550,000 $409,563 $140,437 $45,250 11,000 500 56,750 $ 83,687

Budgeted Balance Sheet June 30, 2012 Assets Cash Accounts receivable ($550,000 40%) Less: allowance for doubtful accounts Inventories Direct materials Finished goods Fixed assets Less: accumulated depreciation $ $220,000 11,000 $ 2,826 81,934 $580,000 470,957 $850,415 $ 10,292 500 100,000 200,000 539,623 $850,415 85,698 209,000 84,760

($90,890 + 45,426 30% + 45,250 10%)) 109,043 Total assets Liabilities and Equity Accounts payable ($51,461 20%) Interest payable Long-term debt Common stock Retained earnings (465,936 +83,687-10,000)) Total liabilities and equity

Haven't found the Essay You Want?

Get your custom essay sample

For Only $13/page