Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Arrangon Ltd . is a company that manufactures and sells a single product called Zoltar. For planning and control purposes they utilize a monthly master

Arrangon Ltd. is a company that manufactures and sells a single product called Zoltar. For planning and control purposes they utilize a monthly master budget, which is developed in advance of the budget year. Their fiscal year end is September 30. A listing of the estimated ledger balances for the company's current year of September 30,202 is given below: The sales forecast consisted of these few lines:
For the year ended September 30,2024: 450,000 units at $42.00 each*
For the year ended September 30,2025: 475,000 units at $43.00 each
For the year ended September 30,2026: 500,000 units at $44.00 each
*Sales for the year ended September 30,2024 are based on actual sales to date and budgeted sales for the duration of the year.
Your investigations of the company's records have revealed the following information:
Sales are seasonal with January, May, July and September being the slowest months with only 5% of sales for each month. February, March, August and December each contribute 8% to the total sales. April and June each account for 10% of total sales. Sales in October account for 13% of the total and peak at 15% in November. This pattern of sales is not expected to change in the next two years. Sales are on a credit basis, with 50% collected during the month of the sale, 35% the following month, and 14% the month thereafter, with 1% of total sales considered uncollectible (bad debt expense). Sales in August and September 2024 are expected to be $1,512,000 and $945,000 respectively. Based on the above collection pattern this will result in Accounts Receivable of $674,730 at September 30,2024, which will be collected in October and November 2024.
1. Prepare the Sales Budget and Schedule of Cash Receipts for the year ended September 30,2025.
image text in transcribed

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

A One Year Accounting Course

Authors: Trevor Gambling

21st Edition

0080130275, 9780080130279

More Books

Students also viewed these Accounting questions

Question

What is the purpose of a retaining wall, and how is it designed?

Answered: 1 week ago

Question

How do you determine the load-bearing capacity of a soil?

Answered: 1 week ago

Question

what is Edward Lemieux effect / Anomeric effect ?

Answered: 1 week ago

Question

Define Management by exception

Answered: 1 week ago