Preview

managerial accounting

Satisfactory Essays
Open Document
Open Document
328 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
managerial accounting
Case 8-29 1.
a.
Sales budget:
April
May
June
Quarter

Budgeted sales in units
35,000
45,000
60,000
140,000

Selling price per unit × $8 × $8 × $8 × $8

Total sales
$280,000
$360,000
$480,000
$1,120,000

b.
Schedule of expected cash collections:

February sales
$ 48,000

$ 48,000

March sales
112,000
$ 56,000

168,000

April sales
70,000
140,000
$ 70,000
280,000

May sales

90,000
180,000
270,000

June sales

120,000 120,000

Total cash collections
$230,000
$286,000
$370,000
$ 886,000

c.
Merchandise purchases budget:

Budgeted sales in units
35,000
45,000
60,000
140,000

Add budgeted ending inventory* 40,500 54,000 36,000 36,000

Total needs
75,500
99,000
96,000
176,000

Less beginning inventory 31,500 40,500 54,000 31,500

Required unit purchases 44,000
58,500
42,000
144,500

Unit cost × $5 × $5 × $5 × $5

Required dollar purchases
$220,000
$292,500
$210,000
$ 722,500

*90% of the next month’s sales in units.

Case 8-29

d.
Budgeted cash disbursements for merchandise purchases:

April
May
June
Quarter

March purchases
$ 85,750

$ 85,750

April purchases
110,000
$110,000

220,000

May purchases

146,250
$146,250
292,500

June purchases

105,000 105,000

Total cash payments
$195,750
$256,250
$251,250
$703,250

2.
Cravat Sales Company

Cash Budget

For the Three Months Ending June 30

April
May
June
Quarter
Cash balance, beginning
$ 14,000
$ 10,250
$ 10,000
$ 14,000
Add receipts from customers (Part 1 b.) 230,000 286,000 370,000 886,000
Total cash available 244,000 296,250 380,000 900,000
Less

You May Also Find These Documents Helpful

  • Powerful Essays

    Ac505 Course Project a

    • 3135 Words
    • 13 Pages

    Therefore, for example Total Cash Collection for April will consist of the last 10% of February sales and 70% of March sales and 20% of April sales: (26,000 Feb units x $10 x 0.10) +(40,000 March units x $10 x 0.70) + (65,000 April units x $10 x 0.20) = $436,000. You have to repeat the same process for May and June that I just did for April, and then add up all three months to get the quarter.…

    • 3135 Words
    • 13 Pages
    Powerful Essays
  • Satisfactory Essays

    Acct301

    • 483 Words
    • 2 Pages

    EXERCISE 7-13 PINK MARTINI CORPORATION Cash Budget For the Quarter Ended March 31, 2012 Beginning cash balance $31,000 Add: Receipts Collections from customers 180,000 Sale of equipment 3,500 Total receipts $183,500 Total available cash $214,500 Less: Disbursements Direct materials 41,000 Direct labor 70,000 Manufacturing overhead 35,000 Selling and administrative expense 45,000 Purchase of securities 12,000 Total disbursements $203,000 Excess of available cash over disbursements 11,500 Financing Borrowings 13,500 Repayments Ending cash balance $25,000 PROBLEM 7-1A DANNER FARM SUPPLY COMPANY Sales Budget 6 Months Ending June 30, 2012 Quarter Six Months 1 2 Expected unit sales 28,000 42,000 70,000 Unit selling price 60 60 60 Total sales $1,680,000 $2,520,000 $4,200,000 DANNER FARM SUPPLY COMPANY Production Budget 6 Months Ending June 30, 2012 Quarter Six Months 1 2 Expected unit sales 28,000 42,000 Add: Desired ending finished goods 12000 18000 Total required units 40,000 60,000 Less: Beginning finished goods units 8,000 12,000 Required production units 32,000 48,000 80,000 DANNER FARM SUPPLY COMPANY Direct Materials Budget—Gumm 6 Months Ending June 30, 2012 Quarter Six Months 1 2 Units to be produced 32,000 48,000 Direct materials per unit 4 4 Total pounds needed for production 128000 192000…

    • 483 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Acct 505 Project A

    • 281 Words
    • 2 Pages

    $650,000 $1,000,000 $500,000 $2,150,000 b. Schedule of expected cash collections: February sales (10%)... $ 26,000 $ 26,000 March sales (70%, 10%) ............. 280,000 $ 40,000 320,000 April sales (20%, 70%, 10%) .... 130,000 455,000 $ 65,000 650,000 May sales (20%, 70%) ............. 200,000 700,000 900,000 June sales (20%) ......... 100,000 100,000…

    • 281 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Elis Printing Case

    • 492 Words
    • 2 Pages

    International Accounting Prof. William Hancock Ellis printing Case Ellis printing Case 1. Prepare Ellis printing Company’s cash budget for the 1st half of 2007 | | | Jan-07 | Feb-07 | Mar-07 | Apr-07 | May-07 | Jun-07 | I. Cash Input | | | | | | | | | Receipt, 1% discount, Month (1st -20th ) | 6,600 | 9,240 | 11,220 | 13,200 | 9,240 | 6,600 | | Receipt, 1% discount, Month+1 (21st - 30th ) | 2,640 | 3,300 | 4,620 | 5,610 | 6,600 | 4,620 | | Receipt, Month+30days | 28,000 | 35,000 | 49,000 | 59,500 | 70,000 | 49,000 | | | Receipt, Month+60days | 2,500 | 4,000 | 5,000 | 7,000 | 8,500 | 10,000 | | | Total Cash Input | | 39,740 | 51,540 | 69,840 | 85,310 | 94,340 | 70,220 | | | | | | | | | | | | II. Cash Output | | | | | | | | | material(10% of M+2 sales) | 8,500 | 10,000 | 7,000 | 5,000 | 2,500 | 2,000 | | | material(10% of M+1 sales) | 7,000 | 8,500 | 10,000 | 7,000 | 5,000 | 2,500 | | | labor(20% of M+2 sales) | 17,000 | 20,000 | 14,000 | 10,000 | 5,000 | 4,000 | | | labor(20% of M+1 sales) | 14,000 | 17,000 | 20,000 | 14,000 | 10,000 | 5,000 | | | G&A expenses | | 8,000 | 8,000 | 8,000 | 8,000 | 8,000 | 8,000 | | | Lease fee | | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | | | Miscellaneous expense | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | | | Interest expense paid | 5,000 | | | | | | | | Purchasing a machine | | | | | | 50,000 | | | Tax | | | | | 75,000 | | 75,000 | | | Total Cash Output | 65,000 | 69,000 | 64,500 | 124,500 | 36,000 | 152,000 | | | | | | | | | | | | III.…

    • 492 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    406 acc midterm 2 q3

    • 407 Words
    • 6 Pages

    Sale Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Variable marketing costs Fixed marketing costs Monthly operating income $ $ $ $ $ $ $ $ 750,000.00 225,000.00 120,000.00 105,000.00 150,000.00 37,500.00 65,000.00 47,500.00 (Sale price per unit * Budgeted production) (Direct materials cost per unit * Budgeted production) (Direct labor cost per unit * Budgeted production)…

    • 407 Words
    • 6 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Case 9-30 Partial Answer

    • 376 Words
    • 2 Pages

    65,000 100,000 50,000 $10 $650,000 Correct! Requirement 1b. Schedule of expected cash collections: February sales $26,000 March sales 280,000 April sales 130,000 May sales June sales Total cash collections $436,000 Correct! Requirement 1c. Merchandise purchases budget: Budgeted unit sales 65,000 100,000 Add desired ending inventory 40,000 Total needs 105,000 Less beginning inventory 26,000 Required purchases in units 79,000 Unit cost $4 Required dollar purchases $316,000 Correct! Requirement 1d. Budgeted cash disbursements for merchandise purchases: Accounts payable 100,000 April purchases 158,000 158,000 May purchases June purchases Total cash disbursements $258,000 Correct!…

    • 376 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Acct 4360

    • 529 Words
    • 2 Pages

    PART I—SALES ANALYSIS The J&J Corporation manufactures television sets, DVD players and MP3 players. The wholesale prices to their customers can vary from under $100 to over $1000, depending on the technical complexity of the item and the quantity purchased. Analyze the following sales data for the company in the following sections: 1. Perform calculations that are relevant to understanding company performance and product 2. What critical issue can you identify for the company by analyzing the financial data? Section 1—Sales Data for 5 years Year 1999 2000 2001 2002 2003 Section II—Sales Data for 2003 Product Line Televisions DVD Players MP3 Players Total Company Forecast $4,678,000 $25,200,000 $2,340,000 $32,218,000 Company Sales $5,946,897 $17,840,691 $5,946,897 $29,734,485 Industry Sales $310,730,000 $131,340,000 $208,430,000 $650,500,000 Company Sales $26,006,196 $27,127,246 $28,206,166 $29,008,143 $29,734,485 Industry Sales $200,460,000 $365,650,000 $450,700,000 $500,800,000 $650,500,000…

    • 529 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Managerial Accounting

    • 628 Words
    • 3 Pages

    Warren Company makes candy. During the most recent accounting period, Warren paid $3,000 for raw materials, $4,000 for labor, and $2,000 for overhead costs that were incurred to make candy. Warren started and completed 10,000 units of candy, of which 7,000 were sold. Based on this information, Warren would recognize which of the following amounts of expense on the income statement?…

    • 628 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    + (100 x $5) Dr Merchandise Inventory 1,300 LIFO • 1/2/20X3 Purchases on account: 500 units @ $6 = $3,000 Dr Merchandis Inventory 2,000 Cr Accounts Payable 2,000 • 1/15/20X3 Sales on account: 300 units @ $8.50 = $2,550 Dr Accounts Receivable 2,550 Cr Sales 2,550 Dr Cost of Goods Sold 1,200 (300 x $4) Dr Merchandise Inventory 1,200 • 1/20/20X3 Purchases on Account: 200 units @ $5 = $1,000 Dr Merchandise Inventory 1,000 Cr Accounts Payable 1,000 • 1/25/20X3 Sales on Account: 300 units @ $8.50 = $2,550 Dr Accounts Receivable 2,550 Cr Sales 2,550 Dr Cost of Goods Sold 1,400 (200 x $5) + (100 x $4) Cr Merchandise Inventory 1,400 b.…

    • 462 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Managerial Accounting

    • 779 Words
    • 3 Pages

    Activity-based costing involves two allocation stages and includes a multitude of cost drivers. The first stage known as ABC assigns costs to pools; which signify the activities of the costs to be incurred. During the second stage the cost pools are allocated to products or cost objects by utilizing cost drivers that measure the object’s use of that activity.…

    • 779 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Management Accounting

    • 660 Words
    • 3 Pages

    Marston Corporation manufactures disposable thermometers that are sold to hospitals through a network of independent sales agents located in the United States and Canada. The sales agents sell a variety of products to hospitals in addition to Marston’s disposable thermometer. The sales agents are currently paid an 18% commission on sales, and this commission rate was used when Marston’s management prepared the following budgeted income statement for the upcoming year. Marston Corporation Budgeted Income Statement Sales Cost of goods sold: Variable Fixed Gross margin Selling and administrative expenses: Commissions Fixed advertising expenses Fixed administrative expenses Net operating income $30,000,000 $17,400,000 2,800,000…

    • 660 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Sample Balance Sheet

    • 393 Words
    • 2 Pages

    Sample Balance Sheet: Example Company Balance Sheet December 31, 2011 ASSETS | | | LIABILITIES | Current assets | | | Current liabilities | | | Cash | $ 2,100 | | | Notes payable | $ 5,000 | | Petty cash | 100 | | | Accounts payable | 35,900 | | Temporary investments | 10,000 | | | Wages payable | 8,500 | | Accounts receivable - net | 40,500 | | | Interest payable | 2,900 | | Inventory | 31,000 | | | Taxes payable | 6,100 | | Supplies | 3,800 | | | Warranty liability | 1,100 | | Prepaid insurance | 1,500 | | | Unearned revenues | 1,500 | | | Total current assets | 89,000 | | | | Total current liabilities | 61,000 | - | Investments | 36,000 | | Long-term liabilities | | | | | | | Notes payable | 20,000 | Property, plant & equipment | | | Bonds payable | 400,000 | | Land | 5,500 | | | | Total long-term liabilities | 420,000 | | Land improvements | 6,500 | | | | | | | Buildings | 180,000 | | | | | | | Equipment | 201,000 | | Total liabilities | 481,000 | | Less: accum depreciation | (56,000) | | | | | | Prop, plant & equip - net | 337,000 | | | | | - | Intangible assets | | | STOCKHOLDERS' EQUITY | | | Goodwill | 105,000 | | | Common stock | 110,000 | | Trade names | 200,000 | | | Retained earnings | 229,000 | | | Total intangible assets | 305,000 | | | Less: treasury stock | (50,000) | | | | | | | Total stockholders' equity | 289,000 | Other assets | 3,000 | | | | | - | Total assets | $770,000 | | Total liab. & stockholders' equity | $770,000 | | sample income statement in the multiple-step format: Sample Products Co. Income Statement For the Five Months Ended May 31, 2012 | |…

    • 393 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    The variances for kitchen wages and utilities were favorable for September, whereas the variances for food and supplies were unfavorable. On a year-to-date basis, the only expense that did not have the same pattern as September was utilities which had a $120 F variance for the month, but an $850 U year-to-date variance.…

    • 1198 Words
    • 9 Pages
    Powerful Essays
  • Powerful Essays

    Assignments

    • 2154 Words
    • 9 Pages

    By using this table, we will be assessing the appraisal by carrying out some calculations for the…

    • 2154 Words
    • 9 Pages
    Powerful Essays
  • Satisfactory Essays

    B) can gain a competitive pricing advantage with knowledge of your costs and operating policies…

    • 848 Words
    • 4 Pages
    Satisfactory Essays