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 $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 50 50 50
Taxes, interest, and dividends 30 30 30
Capital expenditures 140 0 0

Complete the following cash budget.

February March April
Sources of cash
Collections on current sales
Collections on amounts receivable
Total sources of cash
Uses of cash
Payments of accounts payable
Cash purchases
Labor and administrative expenses
Capital expenditures
Taxes, interest, and dividends
Total uses of cash
Net cash inflow
Cash at start of period $140
+ Net cash inflow
= Cash at end of period
+ Minimum operating cash balance $140
= Cumulative short-term financing required

Solutions

Expert Solution

­SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE


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 $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...
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 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...
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 ($) 100,000 110,000 110,000 120,000 130,000 130,000 140,000 150,000 150,000 160,000 Sales ($) 603,000 676,000 655,000 748,000 796,000 785,000 858,000 891,000 935,000 980,000 What is the slope of the "least-squares" best-fit regression line? Please round your answer to the nearest hundredth.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT