Preview

285 B M A B P C 1322

Satisfactory Essays
Open Document
Open Document
563 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
285 B M A B P C 1322
Video Company, Inc., produces and markets two popular video games, High Ranger and Star Bounder. The closing account balances on the company’s balance sheet for last year are as follows: Cash, $18,735; Accounts Receivable, $19,900; Materials Inventory, $18,510; Work in Process Inventory, $24,680; Finished Goods Inventory, $21,940; Prepaid Expenses, $3,420; Plant and Equipment, $262,800; Accumulated Depreciation—Plant and Equipment, $55,845; Other Assets, $9,480; Accounts Payable, $52,640; Mortgage Payable, $70,000; Common Stock, $90,000; and Retained Earnings, $107,804.
Operating budgets for the first quarter of the coming year show the following estimated costs: direct materials purchases, $58,100; direct materials usage, $62,400; direct labor expense, $42,880; overhead, $51,910; selling expenses, $35,820; general and administrative expenses, $60,240; cost of goods manufactured, $163,990; and cost of goods sold, $165,440. Estimated ending cash balances are as follows: January, $34,610; February, $60,190; and March, $51,626. The company will have no capital expenditures during the quarter.
Sales are projected to be $125,200 in January, $105,100 in February, and $112,600 in March. Accounts receivable are expected to double during the quarter, and accounts payable are expected to decrease by 20 percent. Mortgage payments for the quarter will total $6,000, of which $2,000 will be interest expense. Prepaid expenses are expected to go up by $20,000, and other assets are projected to increase by 50 percent over the budget period. Depreciation for plant and equipment (already included in the overhead budget) averages 5 percent of total plant and equipment per year. Federal income taxes (30 percent of profits) are payable in April. The company pays no dividends.

Required
1. Determine the March 31 ending balances for Materials Inventory, Work in Process Inventory, and Finished Goods Inventory.
2. Prepare a budgeted income statement for the quarter ended March 31.
3.

You May Also Find These Documents Helpful

  • Satisfactory Essays

    NAME December 14, 2014 Week 6 Practice Problem 1 XACC/290 General Journal Date Account Titles Debit Credit July 01 Cash 12,000 Common Stock 12,000 1 Equipment 8,000 Accounts Payable 6,000 Cash 2,000 3 Cleaning Supplies 900 Accounts Payable 900 5 Prepaid Insurance 1,800 Cash 1,800 12 Accounts Receivable 3,700 Service Revenue 3,700 18 Accounts Payable 1,500 Cash 1,500 20 Salaries Expense 2,000 Cash 2,000 21 Cash 1,600 Accounts Receivable 1,600 25 Accounts Receivable 2,500 Service Revenue 2,500 31 Gas & Oil Expense 290 Cash 290 31 Dividends 600 Cash 600 Cash Accounts Payable 07/01 12,000 07/01 2,000 07/18 1,500 07/01 6,000 07/21 1,600 07/05 1,800 07/03 900 07/18 1,500 Bal.…

    • 446 Words
    • 24 Pages
    Satisfactory Essays
  • Good Essays

    Adms2510

    • 1797 Words
    • 8 Pages

    C. Calculate the balances for the three accounts: Cost of Goods Sold, Work-in-Process Inventory at 31st October 2011 and Finished Goods inventory at 31st October 2011. (Use the chart below to summarize your totals.) (3 marks)…

    • 1797 Words
    • 8 Pages
    Good Essays
  • Powerful Essays

    CASE 1.3 Just for FEET, Inc. 1. (1) Common-sized Balance Sheet 01/01/1999 01/01/1998 01/01/1997 Current assets: Cash and cash equivalents 2% 18% 37% Marketable securities available for sale - - 9% Accounts receivable 3% 4% 2% Inventory 58% 46% 35% Other current assets 3% 1% 1% Total current assets 65% 69% 84% Property and equipment, net 23% 21% 15% Goodwill, net 10% 8% - Other 1% 1% 2% Total assets 100% 100% 100% Current liabilities: Short-term borrowings - Accounts payable 28% 28% 25% Accrued expenses 7% 5% 3% Income taxes payable 0% 1% 0% Current maturities of long-term debt 2% 2% 1% Total current liabilities 36% 86% 93% Long-term debt and obligations 64% 16% 7% Total liabilities 100% 100% 100% Shareholders' equity Common stock 0% 0% 0% Paid-in capital 77% 82% 87% Retained earnings 23% 18% 13% Total shareholders' equity 100% 100% 100% Total liabilities and shareholders' equity (2) Common-sized Statements of Earnings 1999 1998 1997 Net sales 100.00% 100.00% 100.00% Cost of sales 58.38% 58.46% 57.54% Gross profit 41.62% 41.54% 42.46% Other revenues 0.17% 0.23% 0.23% Operating expenses Store operating 30.01% 29.18% 27.04% Store opening costs 1.76% 1.41% 4.38% Amortization of intangibles 0.27% 0.25% 0.07% General and administrative 3.14% 3.77% 3.07% Total operating expenses 35.18% 34.60% 34.57% Operating income 6.61% 7.17% 8.12% Interest expense -1.04% -0.30% -0.32% Interest income 0.02% 0.29% 1.85% Earnings before income taxes and cumulative effect of change in accounting principle 5.59% 7.15% 9.65% Provision for income taxes 2.15% 2.68% 3.43% Earnings before cumulative effect of a change in accounting principle 3.44% 4.47% 6.22% Cumulative effect on prior years of change in accounting principle - - -0.80%…

    • 642 Words
    • 3 Pages
    Powerful Essays
  • Satisfactory Essays

    The following is the list of changes once the errors were corrected to the Working Trail Balance. Accounts receivable increased by $10,000.00 to show the adjustment in the inventory. Cash increased…

    • 593 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    What are the three sections of a Cash Budget, and what is included in each section?…

    • 526 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    322 B M A J O C 1289

    • 295 Words
    • 4 Pages

    Raven Design is a website design and consulting firm. The firm uses a job cost system, in which each client is a different job. Raven Design traces direct labor, licensing costs, and travel costs directly to each job (client). It allocates indirect costs to jobs based on a pre-determined indirect cost allocation rate computed as a percentage of direct labor costs. At the beginning of the current year, managing partner Jill Herbert prepared the following budget:…

    • 295 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    b. Assume the firm receives an additional $1 million of interest from some bonds it owns. What is the tax on this interest income?…

    • 436 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Sm Ch 23

    • 8470 Words
    • 100 Pages

    Copyright © 2015 by McGraw-Hill Education All rights reserved. No reproduction or distribution without the prior written consent of…

    • 8470 Words
    • 100 Pages
    Powerful Essays
  • Good Essays

    Like in the Production Budget, you’ll also need to make sure you have sufficient raw materials on hand to use in the beginning of the following month. The formula is essentially the same as the Production Budget formula. Once you’ve calculated your raw materials purchases, you also need to figure out how much cash you’ll be paying for these purchases. Similar to cash receipts from sales, cash payments may also be spread out over several months. The question should specify what portion you pay this month, in the next month, etc. You can also use this information to figure out your end “Accounts Payable – Inventory” for the period, which you’ll need later to complete your budgeted Balance Sheet. After raw materials, you may also be asked to estimate your Direct Labor & MOH costs. Lastly, you can calculate your expected COGS. This is just your total estimated unit cost times unit sales (from the Sales Budget). 4) S&A Expense Budget – this is just your estimated S&A Expenses based on your budgeted sales and production. The calculations will probably involved fixed and variable components. Like your raw materials purchases, these expenses will also likely be paid over several months. However, there are two…

    • 1629 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    Week 7 Problem Set

    • 473 Words
    • 2 Pages

    CashAccounts receivableInventory | $ 2,000 3,950 1,300 | Accounts payableNotes payableAccruals | $ 1,500 1,000 1,220 |…

    • 473 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Learnrite.Com Minicase

    • 747 Words
    • 3 Pages

    Marketing and other operating expenses are estimated to be $3 million in 2011 and $5 million in 2012. However, operating cash flow breakeven should be reached during the third year. Net profit margins are expected to average 10 percent per year beginning in Year 3. Investment in bricks and mortar is largely in the form of warehouse facilities and a computer system to handle orders and facilitate the distribution of inventories. After considering the investment in inventories, the asset intensity or turnover is expected to average about two times per year.…

    • 747 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    4. Jetson Spacecraft Corp. shows the following information on its 2009 income statement: sales $ 196,000; costs $ 104,000; other expenses $ 6,800; depreciation expense $ 9,100; interest expense $ 14,800; taxes $ 21,455; dividends $ 10,400. In addition, you’re told that the firm issued $ 5,700 in new equity during 2009 and redeemed $ 7,300 in outstanding long- term debt.…

    • 2006 Words
    • 9 Pages
    Powerful Essays
  • Satisfactory Essays

    Eskimo Pie Case

    • 632 Words
    • 3 Pages

    The company purchased $420k worth of raw materials, which it will use by the end of the year. There was a substantial backlog of orders amounting to $16.5m on 31st August. There was a missing piece of electronic equipment to finish some machines valued at $1,320,000, which was due to arrive and then the orders can be finished. The company needs to stay cash positive on a daily basis in order to finance its operations and business expansion. Based on the information in the case, prepare a projected cash budget for the four months September through December 1979, a projected income statement for the same period, and a pro forma balance sheet as of December 31, 1979.…

    • 632 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Current Assets: Cash 2.30% 6.10% Marketable Securities - 0.7 Accounts Receivable, net 16.0 12.2 Inventory 31.7 24.4 Prepaid Expenses 0.7 0.9 Total…

    • 487 Words
    • 9 Pages
    Satisfactory Essays
  • Powerful Essays

    Kota Fibers

    • 1816 Words
    • 8 Pages

    I have reviewed the Company’s projections and cash flows for the fiscal year ended December 31, 2001 in an attempt to identify: a) the operational issues and opportunities presented by various departments and b) the integrity of the data within the forecasts and cash flows. I have done so with the intent of providing your Company with a more accurate fiscal picture for 2001 and to determine if the Company can meet its fiscal obligations to the bank and other key creditors. The following report is a summary of my findings. Please also refer to Appendix 1 which is a numerical summary of my findings. The excel spreadsheet from which it was derived has been attached to this report for your review. Please note that the Summary has been color coded and referenced in order to assist you in understanding the data and that notes to my file are included on Appendix 2. Note that the summary is a build-up of assumptions/decisions made and should be viewed as a progressive iteration. For example, we start with the assumptions changed to the base model, then we factor in the inventory adjustments, then we factor in Pondicherry sales decisions including any other adjustments made.…

    • 1816 Words
    • 8 Pages
    Powerful Essays