Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Operational Risk Management

Authors: Mark D Abkowitz

1st Edition

0470256982, 9780470256985

More Books

Students also viewed these Accounting questions

Question

2. The purpose of the acquisition of the information.

Answered: 1 week ago

Question

1. What is the meaning of the information we are collecting?

Answered: 1 week ago

Question

3. How much information do we need to collect?

Answered: 1 week ago