B. Problem 1. Galaxy Lighting Company manufactures and sells lighting fixtures. Estimated sales for the next three months are: September P 350,000 October 500,000 November 400,000 Sales for August were $400,000. All sales are on account. Galaxy Lighting Company estimates that 60% of the accounts receivable are collected in the month of sale with the remaining 40% collected the following month. The units sell for $30 each. The cash balance for September 1 is $100,000. Generally, 60% of purchases are due and payable in the month of purchase with the remainder due the following month. Purchase cost per unit for materials is $18. The company maintains an end-of-the-month inventory of 1,000 units plus 10% of next month's unit sales. In addition to the information given, selling and administrative expenses paid in cash are $120,000 per month. Requirement: Prepare a monthly cash budget for September and October for Galaxy Lighting Company.

You collect 75% of a month's sales in the month of the sale and 25% of sales in the following month. May sales June sales July sales O $105 O $35 $120 Compute cash inflows for June. $135 $140 $100 not enough information, because sales revenue differs

Pardee Company makes 30% of its sales for cash and 70% on account. 60% of the account sales are collected in the month of sale, 25% in the month following sale, and 12% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year: Month                   1                      2                      3                      4 Total sales $78,000           $80,000           $68,000           $48,000 Total cash receipts in Month 4 will be: A. 38,780 B.68,000 C.53,180 D.50,600

The table contains the Sales estimates for the next year. The Purchases are 55% of Sales.  Purchases are paid in the following month. The administrative expenses of $11,550 are paid each month Tax expenses of $16,458 are paid in March, June, September, and December each year. Rent expenses of $47,735 are paid in June and December. What is the cash outflow for March? Month Sales $ Month Sales $ Jan         87,400 July         21,931 Feb         89,751 Aug         78,038 Mar         78,038 Sep         87,400 Apr         21,931 Oct         78,038 May         87,400 Nov         89,751 June         89,751 Dec         21,931

Schedule of cash collections of accounts receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 30% pay their accounts in the month of sale, while the remaining 70% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $58,000 November 65,000 December 72,000 The Accounts Receivable balance on September 30 was $35,000. Prepare a schedule of cash collections from sales for October, November, and December. Enter all amounts as positive numbers. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 Line Item Description Receipts from cash sales: Cash sales September sales on account: Collected in October October sales on account: Collected in October Collected in November November sales on account: Collected…

Wiggles Right forecasted sales of $5,000 in October, $4,000 in November, and $4,000 in December. All sales are on credit. 40% is collected the month of sale, and the remainder the following month. How much is collected from accounts receivable in November? Group of answer choices $6,000 $4,600 $5,400 $4,800

Financial information for Strawberry’s Place is as follows: Cash at 1/1/20X1 is $10,000. The firm desires to maintain a minimum balance of $10,000 at the end of each month.     Total monthly sales are as follows: DecemberJanuaryFebruary 20X020X120X1 $120,000150,000 (est.)160,000 (est.)     The sales are 40 percent cash and 60 percent credit card. Visa is the only acceptable credit card at Strawberry’s, and assume the charges are converted to cash the day of the sale. The brokerage charge is 2 percent of the sale.   Expected other income is $2,000 from interest to be received in February. In addition, in January, a range with a net book value of $300 is expected to be sold for cash, resulting in a $1,000 gain on the sale.   Food and beverages are paid for the month following the sale and average 40 percent and 25 percent, respectively. Food sales are four times beverage sales. Total sales consist of only food and beverage sales. Labor is paid for the last day of the month and…

4 Jasper Company has 70% of its sales on credit and 30% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $525,000 for April, $535,000 for May, and $560,000 for June. Total sales for March are $500,000. Prepare a schedule of cash receipts from sales for April, May, and June, ts Book erences Sales Cash receipts from: Total cash receipts JASPER COMPANY Schedule of Cash Receipts from Sales April 525,000 May 535,000 June 560,000

Fernando Company developed the following data for the month of August:1. August 1 cash balance P123,000.2. Cash sales in August P800,000.3. Credit sales for August are P300,000; for July P400,000; and for June P400,000. 70% of credit sales are collected in the month of sale, 15% in thefollowing month, and 10% in the second month following the sale. 4. Purchases for July were P500,000 and for August are P400,000. One-fourth of purchases are paid in the month of purchase and the remaining three-quarters in the following month. 5. August salaries are P314,000, utilities are P32,200, and depreciation on the building and equipment is P100,000. Required:1. Anticipated cash receipts from accounts receivable in August.

Monthly sales for the Garden Centre are shown in the table below. Garden CentreSales Forecast Month Sales January $20,000 February $22,000 March $26,000 April $30,000 May $35,000 June $40,000 The Garden Centre purchases inventory two months in advance. They pay for 50% of the merchandise the month after the purchase, and the other 50% two months after the purchase. The Garden Centre’s gross margin is 40%. What are the Garden Centre’s payments to suppliers in March? Please avoid image based solutions thank you