User Account

All Pages

Calculate the expected cash disbursements for raw material

Assignment Help Managerial Accounting
Reference no: EM132586774

Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation:

The Marketing Department has estimated sales as follows for the remainder of the year (in units):

July42,500

October32,500

August95,000

November19,000

September64,000

December19,500

The selling price of the beach umbrellas is $10 per unit.

All sales are on account. Based on past experience, sales are collected in the following pattern:

30%in the month of sale

65%in the month following sale

5%uncollectible

  • Sales for June totaled $440,000.
  • The company maintains finished goods inventories equal to 15% of the following month's sales. This requirement will be met at the end of June.

Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires that the ending inventory of Gilden be equal to 50% of the following month's production needs.

The inventory of Gilden on hand at the beginning and end of the quarter will be:

June 30100,750feet

September 30?feet

  • Gilden costs $0.40 per foot. One-half of a month's purchases of Gilden is paid for in the month of purchase; the remainder is paid for in the following month. The accounts payable on July 1 for purchases of Gilden during June will be $37,660.

Required:

Question 1. Calculate the estimated sales, by month and in total, for the third quarter.

Question 2. Calculate the expected cash collections, by month and in total, for the third quarter.

Question 3. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October.

Question 4. Calculate the quantity of Gilden (in feet) that needs to be purchased by month and in total, for the third quarter.

Question 5. Calculate the cost of the raw material (Gilden) purchases by month and in total, for the third quarter.

Question 6. Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter.

Reference no: EM132586774

Questions Cloud

Prepare contribution format income statement for the month : Gold Star Rice, Ltd., of Thailand exports Thai rice, Prepare contribution format income statement for the month based on the actual sales data.
Compute company revised break-even point in dollar sales : Compute the company's revised break-even point in dollar sales. Also, compute its revised margin of safety in dollars and margin of safety percentage.
Compute how many balls will have to be sold next year : Compute (a) last year's CM ratio and the break-even point in balls, and (b) the degree of operating leverage at last year's sales level.
Evaluate the cyber division in terms of a balanced scorecard : Salsa Grocery has two divisions. It might be better to evaluate the CYBER division in terms of a balanced scorecard rather than just focusing on EV
Calculate the expected cash disbursements for raw material : Milo Company, Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter.
Is fiscal policy responsible for the national debt : Is fiscal policy responsible for the National Debt? Should the debt be reduced by increasing taxes or limiting spending?
Full-employment output : Fiscal policy can be used to smooth out the business cycle, bringing output down when it's higher than full-employment output
Prepare the company selling and administrative expense : Prepare the company's selling and administrative expense budget for the upcoming fiscal year. (Round "Per Unit" answers to 2 decimal places.)
Find an equation for the aggregate demand curve : Consider an economy with the following IS and LM curves

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Prepare the consolidated financial statements

ACC705 Corporate Accounting and Reporting Assignment - King's Own Institute, Australia. Prepare the consolidated financial statements

  Determine for each year the inventory turnover

Determine for each year the inventory turnover and the number of days' sales in inventory. Round interim calculations to the nearest dollar

  Assignation individual t5ai 4 variance analysis1tooltime

assignation individual t5ai 4 variance analysis1.tooltime has a standard of 1.5 pounds of materials per unit at 2 per

  Freedom of speech and expression are fundamental human

freedom of speech and expression are fundamental human rights that are protected under the u.s. constitution.commonly

  Compute the revised annual depreciation

Compute the revised annual depreciation. On January 1, 2022, the Pharoah Company ledger shows Equipment $42,600 and Accumulated Depreciation

  Managing the cost of complexity

Impact a business and suggest two actions that a business can take in order to minimize these consequences

  Compute the amount of contribution margin

Compute the amount of contribution margin that will be obtained per pound of material used in each product - Compute the amount of contribution margin

  What was the department net $markdown for the sale

What was the department's $NMD for this sale?After the promotion, 16 scarves remained and were returned to their original retail price. What was the $NMD.

  What is the company inventory turnover ratio

Using Sparky's financial information what is the company's inventory turnover ratio for 2012?a. 0.69b. 1.00c. 3.35d.4.03

  Determine the ending finished goods for january

Determine the Ending Finished Goods for January and provide the Job number(s) in Finished Goods at the end of January and determine the total cost

  Vintech company standard costing

Vintech Company is planning to produce 1,800 units of product in 2011. Each unit requires 4 pounds of materials at $6 per pound and a half hour of labor at $17 per hour. The overhead rate is 70% of direct labor

  List and explain the stages involved in project selection

List and explain the stages involved in project selection. Aligning projects with the strategic goals of the organization is crucial for project success.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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