Prepare a budgeted income statement for the month of july

Assignment Help Managerial Accounting
Reference no: EM132951125

Following information relates to Acco Co.

Beginning cash balance on July 1: $35,000.
Cash receipts from sales: 27% is collected in the month of sale, 50% in the next month, and 23% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,204,000; June (actual), $840,000; and July (budgeted), $980,000.
Payments on merchandise purchases: 54% in the month of purchase and 46% in the month following purchase. Purchases amounts are: June (actual), $301,000; and July (budgeted), $600,000.
Budgeted cash payments for salaries in July: $147,700.
Budgeted depreciation expense for July: $8,400.
Other cash expenses budgeted for July: $105,000.
Accrued income taxes due in July: $80,000.
Bank loan interest paid in July: $4,620.

Additional Information:

  • Cost of goods sold is 40% of sales.
  • Inventory at the end of June is $56,000 and at the end of July is $264,000.
  • Salaries payable on June 30 are $35,000 and are expected to be $28,000 on July 31.
  • The equipment account balance is $1,120,000 on July 31. On June 30, the accumulated depreciation on equipment is $196,000.
  • The $4,620 cash payment of interest represents the 1% monthly expense on a bank loan of $462,000.
  • Income taxes payable on July 31 are $115,248, and the income tax rate is 35%.
  • The only other balance sheet accounts are Common Stock, with a balance of $439,260 on June 30; and Retained Earnings, with a balance of $750,400 on June 30.

Problem 1: Prepare a budgeted income statement for the month of July and a budgeted balance sheet for July 31.

Reference no: EM132951125

Questions Cloud

Allocate joint costs to each product : Allocate joint costs to each product using the physical quantities method, and calculate the profit or loss for each product
Explaining the process flow : Construct a flow chart /diagram explaining the process flow a patient who wants to get an Ultrasound scanning done in the hospital - make assumptions as require
What payments for other expenses during the month are : What Payments for other expenses during the month are? 25% of purchases are paid in the month of purchase and the remaining 75% in the following month.
What was the fulton company profit for the year : Fulton Company established Jan 1 2019 several investors paid total 200,000 to purchase fulton shares. What was the Fulton company profit for the year
Prepare a budgeted income statement for the month of july : Beginning cash balance on July 1: $35,000. Prepare a budgeted income statement for the month of July and a budgeted balance sheet for July 31.
What dollar sales level would yellow have : Variable costs are $4 per unit and fixed costs total $120,000 at a volume level of 10,000 units. What dollar sales level would Yellow have
How many units would the company have to sell to attain : Thomas Ltd. sold 4,000 units during the year. How many units would the company have to sell to attain target operating income of $250,000?
Explain systems engineering organization : Identify two organizations: one that you think is effective in carrying out their mission, and one that is less than fully effective.
Real-world example of a social movement : Research some real-world examples of social movements that have been started through social media (an example would be the KONY 2012 campaign).

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd