Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Prince Albert Corporation has forecast the following sales for the first seven months of the year. January $16,000 May $16,000 February 18,000 June 22,000

The Prince Albert Corporation has forecast the following sales for the first seven months of the year.

January $16,000 May $16,000
February 18,000 June 22,000
March 20,000 July 24,000
April 26,000

Monthly material purchases are set equal to 20 percent of forecasted sales for the next month. Of the total material costs, 30 percent are paid in the month of purchase and 70 percent are paid in the following month. Labour costs will run $4,600 per month, and fixed overhead is $5,000 per month. Interest payments on the debt will be $3,600 for both March and June. Finally, the Prince Albert sales people will receive a 1.0 percent commission on total sales for the first six months of the year, to be paid on June 30.

Prepare a monthly summary of cash payments for the six months from January through June. (Note: Compute prior December purchases to help get total material payments for January.)

Prince Albert Corporation Cash Payments Schedule
December January February March April May June July
Sales $ $ $ $ $ $ $
Purchases $
Current month payment
Prior month payment
Total payment for materials
Labour costs
Fixed overhead
Interest payments
Sales commission
Total cash payments $ $ $ $ $ $

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

Understanding Futures Markets

Authors: Robert Kolb, James Overdahl

6th Edition

ISBN: 1405134038, 9781405134033

More Books

Students also viewed these Finance questions

Question

Show that (AB) = B A for A, B IR NN .

Answered: 1 week ago

Question

2. Explain the importance of interpersonal relationships.

Answered: 1 week ago

Question

What are the determinants of cash cycle ? Explain

Answered: 1 week ago