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

    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
  • 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

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

    • 526 Words
    • 3 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
  • 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

    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
  • 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
  • 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

    Purchases of materials for June were $142,600. Direct labor costs were incurred and computed on the basis of 27,000 hours at $8 per hour. Actual overhead costs incurred in June were as follows: operating supplies used, $5,700; janitorial and materials handling labor, $38,100; employee benefits $110,800; heat, light, and power, $50,000; factory depreciation, $8,400; property taxes, $8,000; and expired portion of insurance premiums, $12,000. Net sales for June were $992,700. Selling and administrative expenses were $165,000.…

    • 2411 Words
    • 10 Pages
    Good 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
  • Satisfactory Essays

    Recievable $ 550,000 $ 468,000 Current Liabilities $ 800,000 $ 430,000 Acid-test Ratio 0.69 to 1 1.09 to 1 (quick assets / c.liabilities) D.) Sales on Account $ 5,000,000 $ 4,350,00 Average Recievable $ 390,000 $ 275,000 Turnover of Recievables 12.8 times 15.8 times * sales on account / ave.receivables Ave. age of Receivables: 28.5 days 23.1 days 365 days / turnover E.) Cost of Goods Sold $ 3,875,000 $ 3,450,000 Average Inventory $ 775,000 $ 550,000 Inventory Turnover 5.0 times 6.3 times *…

    • 487 Words
    • 9 Pages
    Satisfactory 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

    Walt Disney Company

    • 256 Words
    • 2 Pages

    The company chosen for the assignment is the “Walt Disney Company.” For the Walt Disney Company, the fiscal year ended October 2, 2010. A strength listed on the balance sheet is the difference of film and television costs for the years 2009 and 2010. In 2009 these costs were $5,125,000,000, but in 2010 the costs dropped to $4,773,000,000. This is a decrease in the costs for film and television costs. On the consolidated statements of cash flows the cash provided by operations decreased from 2008 to 2009 and then increased from 2009 to 2010. A weakness for the Walt Disney Company is that for the years of 2009 and 2010 the shares have decreased drastically from one year to the next. Treasury stock has also decreased. A trend in net income to the Walt Disney Company is from 2008 to 2009 there is a decrease and from 2009 to 2010 there is an increase. It seems that in comparison from 2008-2010 that 2008 had the most net income for the Walt Disney Company. 2009 was the lowest year and 2010 was in the middle. In 2009, the FASB issued guidance to revise the approach to determine when a variable interest entity should be consolidated. The guidance is effective for the company’s 2011 fiscal year and the Walt Disney Company is assessing the potential effect the guidance will have on its financial statements. In 2008 the Walt Disney Company had $91 million bad debt for Lehman Brothers…

    • 256 Words
    • 2 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