Wellness Products, needs a cash budget for September. The following information is available: 1. The cash balance at the beginning of August is 9,000€. 2. Contribution margin is 50% (COGS are 50% of sales) 3. Actual sales for July and expected sales for August, September and October are as shown below. Some customers pay in cash (Cash sales) and others in account as described in the figure below. Customers that pay in account, make the payment the month after. 4. Purchases of inventory (company just resells what they buy) must be done so that the end of month inventory must cover 20% of next month sales. Initial inventory in July was 5.300€. 100% of a month's inventory purchases are paid for during the month of purchase. 1. Prepare a schedule of expected cash collections for August, September & October. 2. Prepare a merchandise purchases budget for July, August, and September. 3. Prepare a schedule of expected cash flow (cash in minus cash out) for August, and September. Cash Sales Credit Sales Total B I U A A July $6500 $20000 $26500 2 August $5250 $30000 $35250 September $7400 $40000 $47400 October $6000 $35000 $41000

Wellness Products, needs a cash budget for September. The following information is available: 1. The cash balance at the beginning of August is 9,000€. 2. Contribution margin is 50% (COGS are 50% of sales) 3. Actual sales for July and expected sales for August, September and October are as shown below. Some customers pay in cash (Cash sales) and others in account as described in the figure below. Customers that pay in account, make the payment the month after. 4. Purchases of inventory (company just resells what they buy) must be done so that the end of month inventory must cover 20% of next month sales. Initial inventory in July was 5.300€. 100% of a month's inventory purchases are paid for during the month of purchase. 1. Prepare a schedule of expected cash collections for August, September & October. 2. Prepare a merchandise purchases budget for July, August, and September. 3. Prepare a schedule of expected cash flow (cash in minus cash out) for August, and September. Cash Sales Credit Sales Total B I U A A July $6500 $20000 $26500 2 August $5250 $30000 $35250 September $7400 $40000 $47400 October $6000 $35000 $41000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Peters Products, a distributor of organic beverages, needs a cash budget for September. The following information is available: The cash balance at the beginning of August is 9,000€. Contribution margin is 50% (COGS are 50% of sales) Actual sales for July and expected sales for August, September and October are as shown below. Some customers pay in cash (Cash sales) and others in account as described in the figure below. Customers that pay in account, make the payment the month after. Purchases of inventory (company just resells what they buy) must be done so that the end of month inventory must cover 20% of next month sales. Initial inventory in July was 5.300€. 100% of a month’s inventory purchases are paid for during the month of purchase. Prepare a schedule of expected cash collections for August, September & October. Prepare a merchandise purchases budget for July, August, and September. Prepare a schedule of expected cash flow (cash in minus cash out) for August, and…
Treasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Done
Petronina Sdn. Bhd. needs a cash budget for October. The following information isavailable:1. The cash balance at the beginning of October is RM9,000.2. The actual sales for August and September and expected sales for October arepresented in Table 1: Table 1: Cash, Credit, and Total SalesItems August(RM) September(RM) October(RM)Cash sales 6,500 5,250 7,400Sales on credit 20,000 30,000 40,000Total sales 26,500 35,250 47,400Credit sales are collected over a 3-month period in the following ratio:i. In the month of sale: 10%ii. In the month following the sale: 70%iii. In the second month following the sale: 18%iv. The remaining 2% is uncollectible3. Purchases of inventory will total RM25,000 for October; 20% will be paid inOctober. Accounts payable from September’s inventory purchases is RM16,000;this will be paid in October.4. Selling and administrative expenses are budgeted at RM13,000 for October; ofthis amount, RM4,000 is for depreciation.5. Equipment costing RM18,000 will be…
Please answer the question What are the estimated cash receipts for March, if 20 percent of sales are cash, 40 percent are credit sales paid in the month after the sale, and 40 percent are credit sales paid 2 months after the sale? Answer it with complete solutions and explanations if needed. Thank you
H ltd is preparing its budget for the second quarter. The following information is available June July August September K’000 K’000 K’000 K’000 Sales 12,500 13,600 17,000 16,800 Direct material purchases 3,450 3,780 2,890 3,150 Direct wages are K1, 300,000 per month. Additional information H ltd sells 10% of its goods for cash. The remainder of customers receive one month’s credit. Payments to creditors are made in the month following purchase. Wages are paid as they are incurred H ltd takes one month’s credit on all overheads Production overheads are K3, 200,000 per month. Selling, distribution and administration overheads amount to K1, 890,000 per month. Included in the amounts for overhead given above…
Styles Abuhatim LLC has given the following particulars. You are required to prepare a cash budget for the three months ending 31st December 2019 Months Sales Materials Wages ( OMR) Over heads (OMR) (OMR) (OMR) August September October 20000 10200 3800 1900 21000 10000 3800 2100 23000 9800 4000 2300 November 25000 10000 4200 2400 December 30000 10800 4500 2500 Credit terms are 1.. Sales /Debtors 10% sales are on Cash, 50% of the credit sales are collected in next month and the balance in the following month 2. Creditors- materials 2 months Wages 1 month -1 month Overheads 3. Cash balance on 1st October is expected to be Ro.8000 4. A machinery will be installed in August at a cost of RO.100000, the monthly instalment of RO.5000 is payable from October onwards 5. Dividend at 10% on preference share capital RO.300,000 will be paid on 1* December 2019 6. Advance to be received for the sale of vehicles RO.20000in December 7. Income tax to be received in December RO.5000
The management of Kirkut Enterprises prepared the following forecasted total sales schedule for the five months ending December 2021 August September October November December R310 000 R330 000 R325 000 R340 000 R410 000 Additional information: Cash sales comprise 40% of total sales. These customers are entitles to a 4% discount. Credit sales are collected as follows: 40% in the month of sale - these customers get a 2% discount 55% in the month after the sale 5% is written off as bad debts Cash receipts for cash sales made for the period August to December will total: O A. R686 000 O B. R1 715 000 O C. R658 560 D. R1 646 400
2019 Sales Cost of Goods Sold Rent Wages Insurance Utilities Auto Maintenance Advertising Other Expenses Total Expenses Net Income Jan 3,250 1,788 525 175 46 220 40 98 2,891 359 Feb 2,700 1,485 525 175 46 225 40 81 2,577 123 Mar 3,855 2,120 525 175 46 285 80 60 116 3,407 448 Tom's Business Income Statement 98 2,900 354 2019 May Jul Aug Sep Oct Nov Dec Total Apr 3,254 3,650 2,850 2,600 2010 2,200 2,250 3,755 4,890 37,264 1,790 2,008 1,106 1,210 1,238 2,065 2,690 20,495 525 525 525 525 525 525 6,300 2,100 175 175 175 175 175 175 46 46 46 46 46 46 550 227 265 210 185 220 230 2,657 40 40 40 80 640 60 147 525 175 46 200 40 110 Jun 588 * º * * * 88 * § 547 1,568 525 175 46 185 80 60 86 3,103 2,724 126 1,430 525 175 46 205 40 78 2,499 101 40 60 2217 (207) 80 60 66 2,372 (172) 68 2,276 (26) 113 3,184 3,952 571 938 240 1,118 34,100 3,164
! Required information SB Exercise E8-5 to E8-10 [The following information applies to the questions displayed below.] Shadee Corporation expects to sell 630 sun shades in May and 420 In June. Each shade sells for $147. Shadee's beginning and ending finished goods Inventories for May are 75 and 55 shades, respectively. Ending finished goods Inventory for June will be 60 shades. E8-10 (Algo) Preparing Budgeted Income Statement [LO 8-3h] Each shade requires a total of $50.00 in direct materials that includes 4 adjustable poles that cost $10.00 each. Shadee expects to have 130 in direct materials inventory on May 1, 80 poles in inventory on May 31, and 110 poles in inventory on June 30. Suppose that each shade takes three direct labor hour to produce and Shadee pays its workers $15 per hour. Additionally, Shadee's fixed manufacturing overhead is $10,000 per month, and variable manufacturing overhead is $13 per unit produced. Additional information: • Selling costs are expected to be 6…
The management of Palind Ltd decide to prepare a Cash Budget for November and December. The following information is available: Sales: Cash Credit Purchases Salaries & Wages Sundry Expenses WY Actual August September October R 194 500 287 300 510 000 72 600 17 800 R 235 700 350 000 490 000 72 600 18 400 R 275 000 410 000 495 000 72 600 22 000 Additional information: 1. Cash in respect of credit sales is collected as follows: • 50% within 30 days • 30% within 60 days • 15% within 90 days • The balance is written off as irrecoverable. 2. The following discounts are allowed on sales: Budgeted 7. The cash in the bank on 31 October was R44 500. November December R 250 500 400 400 520 000 72 600 22 600 R 368 000 697 000 680 000 72 600 25 700 • 10% on cash sales • 7.5% on credit sales if accounts are settled within 30 days. 3. All salaries, wages and sundry expenses are paid in cash. 4. Sundry expenses include depreciation of R4 200 per month. 5. Seventy-five (75%) of all purchases are on…
Below is the exercice and solutions but I don't understand the solution, for example the cash collection from debitors. Thanks for help. Use the information below and prepare a cash budget for April, May, and June. Month Sales Purchases Wages Exp. Jan. (actual) 80,000 45,000 20,000 5,000 Feb. (actual) 80,000 40,000 18,000 6,000 Mar. (actual) 75,000 42,000 22,000 6,000 Apr. forecast 90,000 50,000 24,000 6,000 May forecast 85,000 45,000 20,000 6,000 Jun. forecast 80,000 35,000 18,000 5,000 You are further informed that: 10% of purchases and 20% of sales are for cash. The average collection period of the company is half a month and credit purchases are paid off regularly after one month. Wages are paid half monthly and the rent of $500, excluded in expense, is paid monthly. Cash and bank balance on April 1 was $15,000, and the company aims to keep it below this figure at the end of every month. The…
Using the following data for for Rodriguez Art Studio to prepare a cash follow forecast. - Sales revenue: $10,000 March, $10,000 April, $9,000 May, $11,000 June. - Payment from customers is 50% paid in cash, 50% paid on one months credit - Direct Costs $5,500 April, $4,950 May, $6,060 June. - Opening Cash Balance in April $1,200 - Indirect Costs are $5,100 per month. What is the Total Cash inflow in May? Options -$4,500 -$11,200 -$10,000 -$9,500 What is the Net Cash flow in April? Options -$-600 -$660 -$-610 $600