Question

In: Finance

The following data are from the budget of Ritewell Publishers. Half the company’s sales are transacted...

The following data are from the budget of Ritewell Publishers. Half the company’s sales are transacted on a cash basis. The other half are paid for with a 1-month delay. The company pays all of its credit purchases with a 1-month delay. Credit purchases in January were $140, and total sales in January were $290.

February March April
Total sales $ 420 $ 440 $ 400
Cash purchases 125 135 115
Credit purchases 95 85 95
Labor and administrative purchases 85 85 85
Taxes, interest, and dividends 65 65 65
Capital expenditures 210 0 0

Complete the following cash budget. (Leave no cells blank. Enter '0' when necessary. Negative amounts should be indicated by a minus sign.)

Answer is complete but not entirely correct.

February March April
Sources of cash
Collections on current sales $210selected answer correct $220selected answer correct $200selected answer correct
Collections on amounts receivable $145selected answer correct $210selected answer correct $220selected answer correct
Total sources of cash $355 $430 $420
Uses of cash
Payments of accounts payable $140selected answer correct $95selected answer correct $85selected answer correct
Cash purchases $125selected answer correct $135selected answer correct $115selected answer correct
Labor and administrative expenses $85selected answer correct $85selected answer correct $85selected answer correct
Capital expenditures $210selected answer correct $0selected answer correct $0selected answer correct
Taxes, interest, and dividends $65selected answer correct $65selected answer correct $65selected answer correct
Total uses of cash $625 $380 $350
Net cash inflow $(270)selected answer incorrect $50selected answer correct $70selected answer correct
Cash at start of period $210 $(60)selected answer incorrect $(10)selected answer incorrect
+ Net cash inflow $(270)selected answer correct $50selected answer correct $70selected answer correct
= Cash at end of period $(60) $(10) $60
+ Minimum operating cash balance $210 $210selected answer correct $210selected answer correct
= Cumulative short-term financing required $270 $220 $150

Solutions

Expert Solution


Related Solutions

The following data are from the budget of Ritewell Publishers. Half the company’s sales are transacted...
The following data are from the budget of Ritewell Publishers. Half the company’s sales are transacted on a cash basis. The other half are paid for with a 1-month delay. The company pays all of its credit purchases with a 1-month delay. Credit purchases in January were $70, and total sales in January were $220. February March April Total sales $ 280 $ 300 $ 260 Cash purchases 90 100 80 Credit purchases 60 50 60 Labor and administrative purchases...
The following table lists data from the budget of Ritewell Publishers. Half the company’s sales are...
The following table lists data from the budget of Ritewell Publishers. Half the company’s sales are for cash on the nail; the other half are paid for with a one-month delay. The company pays all its credit purchases with a one-month delay. Credit purchases in January were $30, and total sales in January were $180. Assume all expenses, other than purchases, are cash transactions. February March April Total sales $200 $220 $180 Purchases of materials For cash 70 80 60...
The management of Furrow Corporation is considering dropping product L07E. Data from the company’s budget for...
The management of Furrow Corporation is considering dropping product L07E. Data from the company’s budget for the upcoming year appear below: Sales $ 970,000 Variable expenses $ 393,000 Fixed manufacturing expenses $ 375,000 Fixed selling and administrative expenses $ 255,000 In the company's accounting system all fixed expenses of the company are fully allocated to products. Further investigation has revealed that $243,000 of the fixed manufacturing expenses and $204,000 of the fixed selling and administrative expenses are avoidable if product...
The management of Furrow Corporation is considering dropping product L07E. Data from the company’s budget for...
The management of Furrow Corporation is considering dropping product L07E. Data from the company’s budget for the upcoming year appear below: Sales $ 940,000 Variable expenses $ 390,000 Fixed manufacturing expenses $ 372,000 Fixed selling and administrative expenses $ 252,000 In the company's accounting system all fixed expenses of the company are fully allocated to products. Further investigation has revealed that $237,000 of the fixed manufacturing expenses and $198,000 of the fixed selling and administrative expenses are avoidable if product...
The management of Furrow Corporation is considering dropping product L07E. Data from the company’s budget for...
The management of Furrow Corporation is considering dropping product L07E. Data from the company’s budget for the upcoming year appear below: Sales $ 920,000 Variable expenses $ 388,000 Fixed manufacturing expenses $ 370,000 Fixed selling and administrative expenses $ 250000 In the company's accounting system all fixed expenses of the company are fully allocated to products. Further investigation has revealed that $233,000 of the fixed manufacturing expenses and $194,000 of the fixed selling and administrative expenses are avoidable if product...
The management of Furrow Corporation is considering dropping product L07E. Data from the company’s budget for...
The management of Furrow Corporation is considering dropping product L07E. Data from the company’s budget for the upcoming year appear below: Sales $ 950,000 Variable expenses $ 396,000 Fixed manufacturing expenses $ 378,000 Fixed selling and administrative expenses $ 258,000 In the company's accounting system all fixed expenses of the company are fully allocated to products. Further investigation has revealed that $249,000 of the fixed manufacturing expenses and $210,000 of the fixed selling and administrative expenses are avoidable if product...
The following data is for the month of June for the Sylvie Co. Master Budget: Sales...
The following data is for the month of June for the Sylvie Co. Master Budget: Sales of $8,000,000, variable cost of $4,000,000, and fixed cost of $2,000,000 Actual Results: Sales $9,500,000, variable cost $6,000,000 and fixed cost $2,500,000 Required: Calculate the sales activity and flexible budget variances for the month of June ( 5 column variance analysis ).
Consider the following sample data for the relationship between advertising budget and sales for Product A:...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 50,000 60,000 60,000 70,000 70,000 80,000 90,000 90,000 100,000 110,000 Sales ($) 299,001 371,000 364,000 430,000 440,000 485,000 535,000 546,000 595,000 675,000 What is the predicted sales quantity for an advertising budget of $76,000? Please round your answer to the nearest integer.
Consider the following sample data for the relationship between advertising budget and sales for Product A:...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 50,000 60,000 60,000 70,000 70,000 80,000 90,000 90,000 100,000 110,000 Sales ($) 299,001 371,000 364,000 430,000 440,000 485,000 535,000 546,000 595,000 675,000 What is the correlation value for the relationship between advertising and sales? Please round your answer to the nearest hundredth.
Consider the following sample data for the relationship between advertising budget and sales for Product A:...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 50,000 60,000 60,000 70,000 70,000 80,000 90,000 90,000 100,000 110,000 Sales ($) 299,001 371,000 364,000 430,000 440,000 485,000 535,000 546,000 595,000 675,000 What is the predicted sales quantity for an advertising budget of $76,000? Please round your answer to the nearest integer. Note that the correct answer will be evaluated based...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT