Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the month of August and has assembled the following information to assist in

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

  • Budgeted sales units are 30,000 (July), 70,000 (August), 50,000 (September) and 20,000 (October)
  • Selling price per unit:$15
  • Cash collections:40% in the month of sale.55% in the month following the sale.5% are uncollectible.
  • The company maintains finished goods inventories equal to 20% of the following month's sales.
  • Each beach umbrella requires 5 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.
  • Raw material cost is $0.80 per foot of Gilden.
  • The beginning balance of raw materials for August will be 134,000 feet of Gilden.
  • 60% 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 balance on August 1 for purchases of Gilden during July will be $82,400.

Answer the following questions:

  1. What is the August sales budget in dollars?
  2. How much money will Milo collect during the month of August?
  3. How many units should be produced in the month of August?
  4. How many feet of raw materials (Gilden) should be purchased in August?
  5. What will be the cost of raw materials for the month of August?
  6. What will be the cash disbursements in August?

Enter you answers in the same order as above.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

0130674842, 978-0130674845

Students also viewed these Accounting questions