Prepare a schedule showing the cash disbursements

Assignment Help Managerial Accounting
Reference no: EM132541766

Elf Company manufactures miniature picnic tables to be sold to elementary schools and children daycares. The controller of Elf Company is currently preparing a budget for the second quarter of the year.

The following sales forecast has been made by the sales manager for the first half of 2020:

January 8,500 tables

February 9,000 tables

March 9,500 tables

April 10,000 tables

May 12,000 tables

June 15,000 tables

  • Each table sells for $50 and all sales are on account. Past history has shown that 30% of credit sales are collected in the month that the sale occurred, 40% of the sales are collected the month following the month of sale, 25% of credit sales are collected two months following the month of sale and the remaining 5% is collected in the third month following the sale. The estimated sales for July and August are 16,000 and 16,500 tables respectively. Elf Company had 2,000 tables in finished goods inventory at the end of March. The department ends each month with enough finished-goods inventory to cover 20 percent of the next month's sales.
  • Each picnic table requires 10 board metres of spruce blanks to manufacture. Spruce planks cost $0.50 per board metre, and the production department ends each month with enough wood to cover 10 percent of the next month's production requirements. The company had 10,400 board metres of spruce wood in its ending raw material inventory at the end of March. The purchase of wood is all on account and the company pays 60% of its purchases in the month of purchase and the remaining 40% in the month following the purchase. Purchases of wood in March totalled $48,400.
  • Each table requires 1.5 hours of direct labour to manufacture. The production department incurs a cost of $20 per hour for direct-labour wages and fringe benefits.

Required:

Question a) Prepare the Sales Budget for the quarter ended June 30, 2020.

Question b) Prepare the Production Budget for the quarter ended June 30, 2020.

Question c) Prepare the Raw Material Purchase Budget for the quarter ended June 30, 2020.

Question d) Prepare the Direct Labour Budget for the quarter ended June 30, 2020.

Question e) Prepare a schedule showing the cash collections from sales for the quarter ended June 30, 2020.

Question f) Prepare a schedule showing the cash disbursements for the purchase of raw materials for the quarter ended June 30,2020.

Note: For all the budgets and schedules above, you must show a column for April, May and June as well as a column for the total of Quarter 2 of the year.

Reference no: EM132541766

Questions Cloud

What are some possible reasons for lisa being inactive : What are some possible reasons for Lisa being inactive prior to jumping into problem solving (ise, what are some reasons for Lisa's online behavior)
What two problems will the cause : A client is using the Sales on Account workflow. Instead of receiving a payment against the invoice, What two problems will the cause?
How does a decrease in unemployment benefits : How does a decrease in unemployment benefits affect natural rate of unemployment in an economy?
Lower taxes than low-income canadians : The media often claims that high-income Canadians pay the same or lower taxes than low-income Canadians. Is this a valid claim? Why or why not?
Prepare a schedule showing the cash disbursements : Prepare a schedule showing the cash disbursements for the purchase of raw materials for the quarter. Prepare the Sales Budget for the quarter
Explain why marginal tax rates in canada are higher : Explain why marginal tax rates in Canada are higher than average tax rates.
Important common property resource in canada : The fishery is the most important common property resource in Canada.
Explain fully why the private sector of a free : Explain fully why the private sector of a free enterprise economy cannot produce public goods such as lighthouses.
Are companies required to disclose a separate schedule : Companies are required to disclose a separate Schedule of Cost of Goods Manufactured as part of their financial statements. Select one: True False

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