subject
Business, 13.07.2021 16:40 jayloy4724

You are an accountant at Hostell Homewares Inc. The controller wants you to prepare a monthly cash budget for the next three months, based on the following budget information. September October November
Sales $300,000 $350,000 $325,000
Manufacturing costs $175,000 $200,000 $210,000
Selling and administrative expenses $50,000 $50,000 $55,000
Capital expenditures $200,000
The company expects to sell about 10% of its merchandise for cash. Of sales on account, 65% are expected to be collected in the month following the sale and the remainder the following month (second month following the sale). Depreciation, insurance and property tax expense represent $50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 75% are expected to be paid in the month in which they are incurred and the balance in the following month.
Additionally, the following account balances as of September 1….
Current Assets
Cash$50,000
Marketable securities $75,000
Accounts receivable $327,000
*July portion of A/R $77,000
*August portion of A/R $250,000
Current Liabilities
Accounts Payable $50,000
Other items of note….
Sales on account for….
July $220,000
August $250,000
Selling and administrative costs are paid in the period incurred.
Estimated income tax payment to be made in October$60,000
Regular quarterly dividend declared in October$30,000
Regular quarterly dividend paid in November$30,000
Lastly, Scott's management desires a minimum monthly cash balance of $50,000.
Instructions: Using formulas/functions wherever available, complete the following on the Input tab…
Prepare a monthly cash budget and supporting schedules for September, October, and November.
On the basis of the cash budget prepared in Part 1, what feedback would you give the controller?

ansver
Answers: 3

Other questions on the subject: Business

image
Business, 21.06.2019 16:00, wvtoy4767
Common problems that can arise among groups. explain in four or five sentences what can cause the specific or general problem. in addition, explain what impact that conflict can have on group cohesion as well as productivity.
Answers: 1
image
Business, 22.06.2019 03:30, jose0765678755
Joe finally found a house for sale that he liked. which factor could increase the price of the house he likes? a. both he and the seller each have a real estate agent. b. a home inspector finds faulty wiring in the house. c. the house has been for sale for almost a year. d. several buyers all want that same house.
Answers: 2
image
Business, 22.06.2019 11:40, maddied2443
The following pertains to smoke, inc.’s investment in debt securities: on december 31, year 3, smoke reclassified a security acquired during the year for $70,000. it had a $50,000 fair value when it was reclassified from trading to available-for-sale. an available-for-sale security costing $75,000, written down to $30,000 in year 2 because of an other-than-temporary impairment of fair value, had a $60,000 fair value on december 31, year 3. what is the net effect of the above items on smoke’s net income for the year ended december 31, year 3?
Answers: 3
image
Business, 22.06.2019 16:10, ilovemusicandreading
The brs corporation makes collections on sales according to the following schedule: 30% in month of sale 66% in month following sale 4% in second month following sale the following sales have been budgeted: sales april $ 130,000 may $ 150,000 june $ 140,000 budgeted cash collections in june would be:
Answers: 1
You know the right answer?
You are an accountant at Hostell Homewares Inc. The controller wants you to prepare a monthly cash b...

Questions in other subjects:

Konu
Mathematics, 05.05.2020 11:37