Question
Galaxy Lighting Company manufactures and sells lighting fixtures. Estimated sales for the next three months are: September $ 350,000 October $ 500,000 November $ 400,000
Galaxy Lighting Company manufactures and sells lighting fixtures. Estimated sales for the next three months are:
September | $ 350,000 |
October | $ 500,000 |
November | $ 400,000 |
Sales for August were $400,000 and December is estimated as $420,000. All sales are on account. Galaxy Lighting Company estimates that 80% of the accounts receivable are collected in the month of sale with the remaining 20% collected the following month. The units sell for $40 each.
Generally, 60% of purchases are due and payable in the month of purchase with the remainder due the following month. Purchase cost per unit for materials is $18. The company maintains an end-of-the-month inventory of 1,000 units plus 10% of next months unit sales. Augusts ending inventory is estimated at 1,875 units and Novembers ending inventory is estimated as 2,500 units. The accounts payable balance on August 31 is expected to be $13,500 and should be paid in September.
A) Prepare a sales budget in dollars and units for September, October, and November.
B) Prepare a schedule of cash receipts from customers.
C) Prepare a purchases budget for September, October and November.
D) Prepare a schedule of cash payments for purchases.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started