Reference no: EM132541101
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) what is the Direct Labour Budget for the quarter ended June 30, 2020.
Question e) what is the schedule showing the cash collections from sales for the quarter ended June 30, 2020.
Question f) make schedule showing the cash disbursements for the purchase of raw materials for the quarter ended June 30,2020.
Prepare a list a report about in managerial accounting
: Prepare a List a report or activity you learned about in Managerial Accounting which has impacted a company, either positively or negatively.
|
How much would it cost him to buy the annuity today
: Your uncle is about to retire, and he wants to buy an annuity that will provide him with $5,300 of income a year for 30 years, with the first payment coming
|
What would be the lump-sum payment
: Jose wants to cash in his winning lottery ticket. He can either receive three, $7,000 annual payments starting today, What would be the lump-sum payment
|
What is the bond capital gain or loss yield
: They have a 5-year maturity, semi-annual coupon rate of 12.00%, and a par value of $1000. What is the bond's capital gain or loss yield?
|
Prepare the raw material purchase budget for the quarter
: Prepare the Raw Material Purchase Budget for the quarter ended June 30, 2020. Prepare the Sales Budget for the quarter ended June
|
What amount should be reported as cost of goods sold
: Cloverdale, Inc., uses the conventional retail inventory method to account for inventory. What amount should be reported as cost of goods sold
|
Privacy and security policy for their organization
: Research an article from any company from 2015 until now on how they implemented their Privacy and Security Policy for their organization.
|
Expected return with a standard deviation
: Suppose a risk-free asset has a 3 percent return and a second risky asset has a 15 percent expected return with a standard deviation of 25 percent.
|
What is the total cost of ordering and carrying inventory
: What is the total cost of ordering and carrying inventory? How many orders will be placed during the year? What is the economic ordering quantity?
|