The Prince Albert Corporation has forecast the following sales for the first seven months of the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Prince Albert Corporation has forecast the following sales for the first seven months of the year. January February March April $22,000 May 24,000 June 26,000 July 32,000 Monthly material purchases are set equal to 25 percent of forecasted sales for the next month. Of the total material costs, 35 percent are paid in the month of purchase and 65 percent are paid in the following month. Labour costs will run $5,200 per month, and fixed overhead is $8,000 per month. Interest payments on the debt will be $4,200 for both March and June. Finally, the Prince Albert sales people will receive a 1.5 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.) Sales Purchases. Current month payment. Prior month payment. Total payment for materials Labour costs Fixed overhead Interest payments Sales commission. Total cash payments. 22,000 28,000 30,000 December $ January Prince Albert Corporation Cash Payments Schedule February March April May $ $ $ June The Prince Albert Corporation has forecast the following sales for the first seven months of the year. January February March April $22,000 May 24,000 June 26,000 July 32,000 Monthly material purchases are set equal to 25 percent of forecasted sales for the next month. Of the total material costs, 35 percent are paid in the month of purchase and 65 percent are paid in the following month. Labour costs will run $5,200 per month, and fixed overhead is $8,000 per month. Interest payments on the debt will be $4,200 for both March and June. Finally, the Prince Albert sales people will receive a 1.5 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.) Sales Purchases. Current month payment. Prior month payment. Total payment for materials Labour costs Fixed overhead Interest payments Sales commission. Total cash payments. 22,000 28,000 30,000 December $ January Prince Albert Corporation Cash Payments Schedule February March April May $ $ $ June
Expert Answer:
Answer rating: 100% (QA)
A 1 2 3 4 Sales 5 Purchases 25 of next months sales 6 Current month payment 3... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0078025518
2nd edition
Authors: Stacey Whitecotton, Robert Libby, Fred Phillips
Posted Date:
Students also viewed these accounting questions
-
Superior Industries sales budget shows quarterly sales for the next year as follows: Quarter Sales (units) First . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18,000 Second . . ....
-
Brimson has forecast sales for the next three months as follows: July 4,000 units, August 6,000 units, September 7,500 units. Brimson's policy is to have an ending inventory of 40% of the next...
-
Croy Inc. has the following projected sales for the next five months: Month ...... Sales in Units April ....... 3,850 May ....... 3,875 June ....... 4,260 July ....... 4,135 August ....... 3,590...
-
Create a use case diagram that would illustrate the use cases for the following dentist office system: Whenever new patients are seen for the first time, they complete a patient information form that...
-
On January 1, 2012, Hampton, Inc. issues $3 million of 5-year, 10% bonds with interest payable on July 1 and January 1. Hampton prepares financial statements on December 31 and amortizes any discount...
-
Suppose the sales price per square foot of homes follows an approximate normal distribution. If you construct a box plot based on a large dataset for this variable, about what percentage of the...
-
What are the steps in developing a personal investment plan?
-
The bank portion of the bank reconciliation for Carlin Company at November 30, 2012, is shown here and on the next page. The adjusted cash balance per bank agreed with the cash balance per books at...
-
banks withdraw currency from the Fed. the Fed makes loans at the discount window. the Fed sells securities on the open market. the Fed buys securities on the open market. 6. Of the above operations...
-
Using the STUDENT table structure shown in Table P6.4, do the following: a. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all transitive...
-
Microsoft shares are currently trading at $100. The price of a two-year call option on Microsoft, struck at K = 80, is $30. The continuously-compounded risk-free rate of interest is 5%. (a) How much...
-
State the objectives of the audit of commitments and contingencies.
-
One procedure for determining the existence of property and equipment is physical observation, although other methods may be as effective in some cases. Discuss means of gathering evidence as to the...
-
What are the purposes of the review of operations?
-
Describe the GAAP hierarchy for nongovernment entities.
-
A telecommunications company provided its cable TV subscribers with free access to a new sports channel for a period of one month. It then chose a sample of 400 television viewers and asked them...
-
Using Google dorks, find two useful queries that will make anattacker??s job easier.Give a real-world example of each query andexplain how an attacker could leverage the output of the query forthe 1...
-
Simplify the expression. Assume that all variables are positive. 23VI1 2 V44 8
-
Explain the balanced scorecard approach to performance evaluation. What advantages does this approach have over using only financial measurements?
-
Why are profit center managers evaluated on segment margin instead of net operating income?
-
Suppose your company's income statement reports $160 of net income, and its comparative balance sheet indicates the following. Required: 1. Prepare the operating activities section of the statement...
-
For the following, determine if the given point is a removable singularity, an essential singularity, or a pole (indicate its order). a. \(\frac{1-\cos z}{z^{2}}, \quad z=0\). b. \(\frac{\sin...
-
Find the Laurent series expansion for \(f(z)=\frac{\sinh z}{z^{3}}\) about \(z=0\). [You need to first do a MacLaurin series expansion for the hyperbolic sine.]
-
Find the residues at the given points: a. \(\frac{2 z^{2}+3 z}{z-1}\) at \(z=1\). b. \(\frac{\ln (1+2 z)}{z}\) at \(z=0\). c. \(\frac{\cos z}{(2 z-\pi)^{3}}\) at \(z=\frac{\pi}{2}\).
Study smarter with the SolutionInn App