Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Health World | |||||
Collection of Sales Revenue | Gross Revenue | Collection % | April | May | June |
April Sales revenue collected in April | 8,000.00 | 97% | 7,760.00 | ||
May Sales revenue collected in May | 7,200.00 | 97% | 6,984.00 | ||
June Sales revenue collected in June | 8,500.00 | 97% | 8,245.00 | ||
Collection of Service Revenue | |||||
March Sales revenue collected in April | 4,700.00 | 25% | 1,175.00 | ||
April Sales revenue collected in April | 5,500.00 | 75% | 4,125.00 | ||
April Sales revenue collected in May | 5,500.00 | 25% | 1,375.00 | ||
May Sales revenue collected in May | 6,300.00 | 75% | 4,725.00 | ||
May Sales revenue collected in June | 6,300.00 | 25% | 1,575.00 | ||
June Sales revenue collected in June | 7,100.00 | 75% | 5,325.00 | ||
Expected Cash Collections | 13,060.00 | 13,084.00 | 15,145.00 |
E6-34 (similar to) Question Help Health World is a retail store selling home oxygen equipment Health...
E6-34 (similar to) Health World is a retail store selling home oxygen equipment. Health World also services home oxygen equipn due to a recent advertising campaign. The forecast of sales and service revenue for March-June 2018 is as fc (Click the icon to view the forecast of sales and service revenue.) (Click the icon to view the coll Read the requirements. Requirement 1. Calculate the cash that Health World expects to collect in May and in June 2018. Show calcu...
20-34 (Simal 10 World is a real store selling home oxygen equipment. He World also services home oxygen equipment for which the company is customers monthly Heath World has budgeted for increases in service revenue of $800 each Onth due to a recent advertising campaign. The forecast of sales and service revenue for March June 2018 is as follows: Click the icon to view the forecast of sales and service revenue) Click the icon to view the collection information) Beard...
Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year, as shown in the company’s sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $300,000 $500,000 $200,000 $1,000,000 From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 70% are collected in the month following sale, and the...
CASH FLOW FORECAST Happy Manufacturing had sales of $65,000 in March and $75,000 in April. Forecast sales for May, June and July are $85,000, $95,000, and $120,000, respectively Given the following data, calculate monthly net cash flow for the months of May, June, and July (1) The firm makes 20% of sales for cash; 30 % are collected in the next month, and the remaining 50% are collected in the second month following the sale. The firm receives other income...
I need help wit required 1 and required 2
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Budgeted sales (all on account) April $420,000 May $620,000 June Total $240,000 $1,280,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 65%...
HW 5 (Chapter 8) i Saved Help Save & Exit Submit Check my work 1 Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: 50 points Budgeted sales (all on account) April S470,000 May $670,000 June $230,000 Total $1,370,000 From past experience, the company has learned that 25% of a month's sales are...
Crane Products, a rapidly
growing distributor of home gardening equipment, is formulating its
plans for the coming year. Carol Jones, the firm’s marketing
director, has completed the following sales forecast.
Crane Products, a rapidly growing distributor of home gardening equipment, is formulating its plans for the coming year. Carol Jones, the firm's marketing director, has completed following sales forecast. Month January February March April May June Sales $903,800 $1,001,200 $903,800 $1,150,300 $1,252,100 $1,407,500 Month July August September October November December...
6) (12 points) Using all the information from the tables above, complete the revised cash budget below. June Quarter Garden Sales, Inc. Cash Budget For the Quarter Ended June 30 April May Beginning cash balance Add collections from customers Total cash available Less cash disbursements: Purchases for inventory Selling & Administrative expenses Land purchases Dividends paid Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance 7) (1.5 points) If the...
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: Budgeted monthly absorption costing income statements for April–July are:Sales are 20% for cash and 80% on account.Sales on account are collected over a three-month period with 10%...
P4-9 (similar to) A Question Help Cash budget-Basic Grenoble Enterprises had sales of $49.700 in March and $60,200 in April. Forecast sales for May, June, and July are $69,700, $79,800, and $99,600, respectively. The firm has a cash balance of $4,800 on May 1 and wishes to maintain a minimum cash balance of $4,800. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 17% of sales for...