Question
Galaxy Lighting Company manufactures and sells lighting fixtures. Estimated sales for the next three months are: September: 350000 October: 500,000 November: 400,000 Sales for August
Galaxy Lighting Company manufactures and sells lighting fixtures. Estimated sales for the next three months are:
September: 350000
October: 500,000
November: 400,000
Sales for August were $400,000. All sales are on account. Galaxy Lighting Company estimates that 60% of the accounts receivable are collected in the month of sale with the remaining 40% collected the following month. The units sell for $25 each. The cash balance for September 1 is $100,000.
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 $15. The company maintains an end-of-the-month inventory of 10% of next month's unit sales.
Selling and administrative expenses paid in cash are $120,000 per month.
how to prepare a monthly cash budget for September for Galaxy Lighting Company?
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