Finish the following Cash Budget CASH BUDGET JAN FEB MAR APRIL MAY JUNE JULY AUG SEPT...

Finish the following Cash Budget

CASH BUDGET
		JAN	FEB	MAR	APRIL	MAY	JUNE	JULY	AUG	SEPT	OCT	NOV	DEC
SALES		200,000	230,000	150000	210,000.00	220,000.00	170,000.00	160,000.00	150,000.00	180,000.00	210,000.00	220,000.00	210,000.00
COLLECTIONS:
No cash Sales
30 days	50%
60 days	50%

TOTAL CASH RECEIPTS

CASH DISBURSEMENTS
SUPPLIES	70%
PAYABLES/SUPPLIES	paid next month(in 30 days)
SALARIES/OVER	monthly	40000
INTEREST	monthly	1000
DIVIDENDS	monthly	1000
TAXES	quarterly			1200

TOTAL DISBURSEMENT		42000	0	1200	0	0	0	0	0	0	0	0	0

NET CHANGE IN CASH
BEGINNING CASH		10000	0	0	0	0	0	0	0	0	0	0	0
FINANCING NEEDED		0	0	0	0	0	0	0	0	0	0	0	0
ENDING CASH
	starting loan balance
CUMMULATIVE BORROWING	100,000

Expert Solution

		JAN	FEB	MAR	APRIL	MAY	JUNE	JULY	AUG	SEPT	OCT	NOV	DEC
SALES		200,000	230,000	150000	210,000.00	220,000.00	170,000.00	160,000.00	150,000.00	180,000.00	210,000.00	220,000.00	210,000.00
COLLECTIONS:
30 days	50%		100000	115000	75000	105000	110000	85000	80000	75000	90000	105000
60 days	50%			100000	115000	75000	105000	110000	85000	80000	75000	90000	105000
TOTAL CASH RECEIPTS			100000	215000	190000	180000	215000	195000	165000	155000	165000	195000	105000
SUPPLIES	70%
SUPPLIES	paid next month		140000	161000	105000	147000	154000	119000	112000	105000	126000	147000	154000
SALARIES	monthly	40000	40000	40000	40000	40000	40000	40000	40000	40000	40000	40000	40000
INTEREST	monthly	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000
DIVIDENDS	monthly	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000
TAXES	quarterly			1200			1200			1200			1200
TOTAL		42000	182000	204200	147000	189000	198000	161000	154000	148200	168000	189000	198200
NET CHANGE IN CASH		(42000)	(82000)	10800	43000	(9000)	17000	34000	11000	6800	(3000)	6000	(93200)
FINANCING NEEDED		(32000)	(114000)	(103200)	(60200)	(69200)	(52200)	(18200)	(7200)	(400)	(3400)	2600	(90600)
CUMMULATIVE BORROWING	100,000

jeff jeffy answered 3 years ago

Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 19 23...

Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 19 23 15 14 13 16 15 17 19 20 20 23 Using a method of trend projection, the forecast for the next month (Jan) = nothing sales (round your response to two decimal places).

Cash Budget - The following information applies to Company A: Jan. Feb. Mar. Apr. Miscellanous cash...

Cash Budget - The following information applies to Company A: Jan. Feb. Mar. Apr. Miscellanous cash payments $25,000 $30,000 $22,000 $32,000 Nov. Dec. Jan. Feb. Mar. Apr. Sales $200,000 $325,000 $250,000 $240,000 $260,000 $270,000 Assume Company A collects 20% of its sales in the month of the sale, 50% the next month, 25% the following month, and 5% is never collected. Dec. Jan. Feb. Mar. Apr. Purchases $210,000 $150,000 $170,000 $180,000 $190,000 Assume Company A makes cash payments of 40%...

AVERAGE EMPLOYMENT LEVELS FOR SEAT OF KNOWLEDGE jan feb mar apr may jun jul aug...

AVERAGE EMPLOYMENT LEVELS FOR SEAT OF KNOWLEDGE jan feb mar apr may jun jul aug sep oct nov dec machine/fabricating 47 47 50 49 51 51 52 51 51 50 52 53 shipping/recieving 24 23 25 25 25 23 24 24 24 24 24 24 welding 30 31 34 34 33 32 32 33 33 38 43 43 paint/assembly 26 30 30 30 29 36 34 33 36 37 36 35 TURNOVER Date Department Reason 04/12 Machining/Fabricating Other...

Jan 523.9 Feb 510.23 March 545.65 April 514.23 May 550.71 June 505.34 July 525.34 August 600...

Jan 523.9 Feb 510.23 March 545.65 April 514.23 May 550.71 June 505.34 July 525.34 August 600 Sept. 569.42 October 500.2 Novem. 533.12 December 507.11 What percentage of your bills are within two standard deviations of the mean?

Tuscarora, Inc., a merchandising company, has the following budgeted figures: Jan Feb Mar April Sales $57,300...

Tuscarora, Inc., a merchandising company, has the following budgeted figures: Jan Feb Mar April Sales $57,300 $60,000 $83,000 $98,000 Cost of goods sold 50% of sales Required ending inventory $10,000 + 30% of next month's sales Inventory on hand on Jan 1 $30,000 Calculate the budgeted purchases for the month of January. A. $28,000 B. $26,650 C. $650 D. $56,650

Tuscarora, Inc., a merchandising company, has the following budgeted figures: Jan Feb Mar April Sales $54,000.00...

Tuscarora, Inc., a merchandising company, has the following budgeted figures: Jan Feb Mar April Sales $54,000.00 $69,000.00 $86,000.00 $95,000.00 Cost of goods sold 50% of sales Required ending inventory $10,000.00 + 20% of next month's sales Inventory on hand on Jan 1 $27,500.00 Calculate the budgeted purchases for the month of January. A. $50,800.00 B. $23,300.00 C. $3,200.00 D. $23,800.00 Nyree Company is preparing its budget for the third quarter. The cash balance on June 30 was $32,000.00. Additional budgeted...

Using basic Python 2. Given the following dictionary: speed ={'jan':47, 'feb':52, 'march':47, 'April':44, 'May':52, 'June':53, 'july':54,...

Using basic Python 2. Given the following dictionary: speed ={'jan':47, 'feb':52, 'march':47, 'April':44, 'May':52, 'June':53, 'july':54, 'Aug':44, 'Sept':54} Get all values from the dictionary and add it to a new list called speedList, but don’t add duplicates values to the new list. Your code should print out: speedList [47, 52, 44, 53, 54] 3. Given the following list of numbers: numberList = [10, 20, 33, 46, 55, 61, 70, 88, 95] First iterate the list and print only those numbers,...

Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of...

Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of goods ($ millions) 32 28 25 22 20 20 a. Forty percent of goods are supplied cash-on-delivery. The remainder are paid with an average delay of one month. If Dynamic Futon starts the year with payables of $22 million, what is the forecasted level of payables for each month? (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.)...

Zira Co. reports the following production budget for the next four months. April May June July...

Zira Co. reports the following production budget for the next four months. April May June July Production (units) 654 695 687 667 Each finished unit requires five pounds of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month’s production needs. Beginning raw materials inventory for April was 981 pounds. Assume direct materials cost $3 per pound. Prepare a direct materials budget for April, May, and June. (Round your intermediate...

Cash Budget Problem: Francesca’s Fragrances, Inc. Prepare Cash Budget for April, May, June 2019 Follow the...

Cash Budget Problem: Francesca’s Fragrances, Inc. Prepare Cash Budget for April, May, June 2019 Follow the following to prepare the budget: 1. Real Sales 2019: January - $200,000 February - $400,000 March - $350,000 Projected for 2019: April - $500,000 May - $400,000 June - $450,000 Sales Payment History: 10% cash 30% Accts. Rec. – collected n/30 days 60% Accts. Rec. – collected...

Question