Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PrimeTime Sportswear is a custom imprinter that began operations six months ago. Sales have exceeded management's most optimistic projections. Sales are made on account and

PrimeTime Sportswear is a custom imprinter that began operations six months ago. Sales have exceeded management's most optimistic projections. Sales are made on account and collected as follows: 52% in the month after the sale is made and 47% in the second month after sale. Merchandise purchases and operating expenses are paid as follows:

In the month during which the merchandise is purchased or the cost is incurred 75 %
In the subsequent month 25 %

PrimeTime Sportswear's income statement budget for each of the next four months, newly revised to reflect the success of the firm, follows:

September October November December
Sales $ 42,400 $ 54,200 $ 67,800 $ 59,300
Cost of goods sold:
Beginning inventory $ 5,980 $ 14,830 $ 20,480 $ 22,230
Purchases 38,500 43,900 48,600 33,100
Cost of goods available for sale $ 44,480 $ 58,730 $ 69,080 $ 55,330
Less: Ending inventory (14,830 ) (20,480 ) (22,230 ) (20,010 )
Cost of goods sold $ 29,650 $ 38,250 $ 46,850 $ 35,320
Gross profit $ 12,750 $ 15,950 $ 20,950 $ 23,980
Operating expenses 10,400 12,400 14,400 16,500
Operating income $ 2,350 $ 3,550 $ 6,550 $ 7,480

Cash on hand August 31 is estimated to be $39,910. Collections of August 31 accounts receivable were estimated to be $17,230 in September and $15,260 in October. Payments of August 31 accounts payable and accrued expenses in September were estimated to be $24,230. Required: a-1. Prepare a cash budget for October and November. (Beginning cash should be indicated with a minus sign if it is a negative amount.)

b-1. Assume now that PrimeTime Sportswear is a mature firm, and that the SeptemberNovember data represent a seasonal peak in business. Prepare a cash budget for December, January, and February, assuming that the income statements for January and February are the same as December's. (Beginning cash should be indicated with a minus sign if it is a negative amount.)

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

Sound Investing, Chapter 6 - Valuation Of Assets And Liabilities

Authors: Kate Mooney

1st Edition

0071719288, 9780071719285

More Books

Students also viewed these Accounting questions