Create a merchandise purchases budget for july

Assignment Help Managerial Accounting
Reference no: EM132514555

Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below:

Beech Corporation

Balance Sheet June 30

Assets

Cash $76,000

Accounts receivable 137,000

Inventory 86,100

Plant and equipment, net of depreciation 230,000

Total assets $529,100

Liabilities and Stockholders' EquityAccounts payable $91,000

Common stock 312,000

Retained earnings 126,100

Total liabilities and stockholders' equity$ 529,100

Beech's managers have made the following additional assumptions and estimates:

  1. Estimated sales for July, August, September, and October will be $410,000, $430,000, $420,000, and $440,000, respectively.
  2. All sales are on credit and all credit sales are collected. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July.
  3. Each month's ending inventory must equal 30% of the cost of next month's sales. The cost of goods sold is 70% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July.
  4. Monthly selling and administrative expenses are always $58,000. Each month $8,000 of this total amount is depreciation expense and the remaining $50,000 relates to expenses that are paid in the month they are incurred.
  5. The company does not plan to borrow money or pay or declare dividends during the quarter ended September 30. The company does not plan to issue any common stock or repurchase its own stock during the quarter ended September 30.

directions:

Question 1. Create a schedule of expected cash collections for July, August, and September.

Question 2-a. Create a merchandise purchases budget for July, August, and September. Also compute total merchandise purchases for the quarter ended September 30.

Question 2-b. Create a schedule of expected cash disbursements for merchandise purchases for July, August, and September.

Question 3. Create a income statement that computes net operating income for the quarter ended September 30.

Question 4. Create a balance sheet as of September 30.

Reference no: EM132514555

Questions Cloud

What is the break even point in dollars : Operating expenses consist of $900,000 of variable costs and $800,000 of fixed costs. What is the break even point in dollars
Estimate of the population mean µ : a. If X = 85, s = 8, and n = 64, construct a 95% confidence interval estimate of the population mean µ.
Show that the posterior distribution is pa : Let thetahave Pareto Pa(thetha 0, a) distribution. Show that the posterior distribution is Pa(max(theta 0, x1. .... xn} alpha+n).
Journalize the first monthly payment : Edward Company purchased a building with a market value of $310,000. Journalize the first monthly payment of $3,781 on January 31, 2018
Create a merchandise purchases budget for july : Create a merchandise purchases budget for July, August, and September. Also compute total merchandise purchases for the quarter ended September
Journalize the first note payment on december : On January 1, 2018, LeMay-Finn signed a $420,000, 7-year, 5% note. Journalize the first note payment on December 31, 2018
Prepare the bank reconciliation for june : Prepare the bank reconciliation for June 30 and make the journal entries that Apples Galore, Inc. should record on June 30 to update its cash account
Personal and organization policy : Discuss the steps that are associated with a job analysis process. Based on your personal experience, why do you think the job analysis process is important?
Prepare amortization schedule for the Fair value : Prepare amortization schedule for the Fair value/book value differences to include the initial amounts determined and amortization expense for 2017

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