Hello,

Could you please explain to me how the cost of goods manufactured is calculated? On the example below it says: 11,500, but I need to be able to understand what components (DL, DM etc.) were used to calculate this number.

Sorry if the data is all scattered. I am still trying to figure out my uploads keep failing.

Thank you!

Little Annin Flagmakers Cost of Goods Sold Budget (USD) Cost of Goods Sold(FIFO) Units Cost/Unit Total Cost Beg finished goods inv. 410 75 30750 Add: Cost of goods manuf. 11500 75 862500 Good available for sale 893250 Less: Ending finished goods 500 75 37500 855750

Input Data (all currency in US$) Yellow-use only cell references Little Annin Flagmakers Blue-may type numbers here Sales Budget (US$) Budgeted Sales Expected April May June Quarter April (units) 2,500 Budgeted sales (units) 2,500 6,000 3,000 11,500 May (units) 6,000 Selling price per unit $120 $120 $120 $120 June (units) 3,000 Total Sales $300,000 $720,000 $360,000 $1,380,000 $1,380,000 July (units) 2,500 August (units) 2,000 Little Annin Flagmakers Selling Price/Unit $120.00 Schedule of Expected Cash Collections (US$) Notes April May June Quarter A/R March 31st = 132,000 Cash Collection Pattern Accounts receivable April's collection 300,000*.4 120000 Month of sale 40% Beginning balance $132,000 $132,000 Secon collection for April on May 132,000*.55 165000 Following month 55% Uncollectible 5% April sales $120,000 $165,000 $285,000 Cash Payments for Materials May sales $288,000 $396,000 $684,000 Month of purchase 40% Following month 60% June sales $144,000 $144,000 Production Requirements Total Cash Collections $252,000 $453,000 $540,000 $1,245,000 $1,245,000 Raw material per unit (lb.) 5 Raw material cost per lb. $7.00 Accounts Receivable as of June 30 $198,000 $198,000 Direct labor hours per unit 0.5 Direct labor rate per hour $40.00 Little Annin Flagmakers Variable MOHD per direct labor hour $10.00 Production Budget Fixed MOHD per month $57,950 April May June Quarter July August Depreciation in fixed MOHD $20,000 Budgeted sales 2,500 6,000 3,000 11,500 2,500 2,000 Add: Desired ending inventory 1,200 600 500 500 400 400 Selling & Administrative (S&A) Costs Total needs 3,700 6,600 3,500 12,000 2,900 2,400 Variable S&A cost per unit sold $1.25 Less: Beginning inventory 410 1,200 600 410 500 400 Fixed S&A cost per month $63,000 Required Production 3,290 5,400 2,900 11,590 2,400 Depreciation in fixed S&A cost $10,000 11,590 Little Annin Flagmakers Other Cash Outflows Direct Materials Budget (US$) Cash dividends paid each month $15,000 April May June Quarter Notes Equipment purchases May $47,820 Required production in units 3,290 5,400 2,900 11,590 Desired ending inv Equipment purchases June $154,600 Raw materials per unit (lbs.) 5 5 5 5 April:27,000*.4 = 10800 Production needs (lbs.) 16,450 27,000 14,500 57,950 May:14,500*.4 = 5800 Desired Ending Inventory Add: Desired ending inventory 10,800 5,800 4,800 4,800 June:2500*5*.4 = 4800 Finished goods 20% Total needs 27,250 32,800 19,300 62,750 Raw materials 40% Less: Beginning inventory 4600 10,800 5,800 4,600 Cash $30,000 Raw materials to be purchased 22,650 22,000 13,500 58,150 Cost of raw materials $7.00 $7.00 $7.00 $7.00 Beginning Account Balances as of March 31 Total Cost of Raw Materials $158,550 $154,000 $94,500 $407,050 $407,050 Cash $37,745 Accounts receivable $132,000 Finished goods inventory $30,750 Little Annin Flagmakers Finished goods cost per unit $75.00 Schedule of Expected Cash Disbursements for Material (US$) Finished goods inventory (units) 410 April May June Quarter Raw materials inventory $32,200 Accounts payable Raw materials (lb.) 4,600 Beginning balance $55,000 $55,000 Accounts payable $55,000 April purchases $63,420 $95,130 $158,550 Land $520,000 Buildings and equipment $1,800,000 May purchases $61,600 $92,400 $154,000 Accumulated depreciation ($750,000) Common stock $500,000 June purchases $37,800 $37,800 Retained earnings $1,247,695 Total Cash Disbursements for Materials $118,420 $156,730 $130,200 $405,350 $405,350 Accounts Payable as of June 30 $56,700 $56,700 Little Annin Flagmakers Direct Labor Budget (US$) April May June Quarter Units to be produced 3,290 5,400 2,900 11,590 Direct labor hours per unit 0.5 0.5 0.5 0.5 Total direct labor hours needed 1,645 2,700 1,450 5,795 Direct labor cost per hour $40.00 $40.00 $40.00 $40.00 Total Direct Labor Cost $65,800 $108,000 $58,000 $231,800 $231,800 Little Annin Flagmakers Manufacturing Overhead Budget(US$) April May June Quarter Budgeted direct labor hours 1,645 2,700 1,450 5,795 Variable MOHD rate $10 $10 $10 $10 Total variable MOHD $16,450 $27,000 $14,500 $57,950 Fixed MOHD expense $57,950 $57,950 $57,950 $173,850 Total MOHD expense $74,400 $84,950 $72,450 $231,800 Less: Depreciation $(20,000) $(20,000) $(20,000) $(60,000) Cash Disbursements for MOHD $54,400 $64,950 $52,450 $171,800 $171,800 MOHD rate (per DLH) $40.00 $40.00 Little Annin Flagmakers Unit Product Cost (US$) Absorption cost per unit Quantity Cost Cost/unit Direct materials 5 $7.00 $35.00 Direct labor 0.50 $40.00 $20.00 Manufacturing overhead 0.50 $40.00 $20.00 Unit Product Cost $75.00 $75.00 Little Annin Flagmakers Cost of Goods Sold Budget (USD) Cost of Goods Sold (FIFO) Units Cost/unit Total Cost Beginning finished goods inventory 410 $75.00 $30,750 Add: Cost of goods manufactured Good available for sale $900,000 Less: Ending finished goods inventory Cost of Good Sold