Managerial Accounting Assignment (Due: May 1, 2022 at 11:30 P.M.Managerial Accounting Assignment...

Question

Managerial Accounting Assignment (Due: May 1, 2022 at 11:30 P.M.
Managerial Accounting Assignment (Due: May 1, 2022 at 11:30 P.M.
This is an excel assignment where we have to input the information into the cells. I really need all answer to be co
ect and I believe I have to use the cells to answer the questions. So can you please answer it so it looks like this format even if you have to write into the cells and scan it back to me. I need to have the answer as well as what cells to multiply, divide, subtract, add, etc. to get to that answer. I appreciate your help. Please and Thank you.

acct-project-yriyickr.pptx

Sandeep · Accepted Answer

Sheet1
	Ans 1	Expected Cash Collections :
		March Cash Collections 	$5,100
		March Collections on account :
		    January Sales	$3,750
		    Februrary Sales 	$19,500
		    March Sales 	$29,500
		Total Cash collections 	$57,850
		Payment to Suppliers :
		Account payable for Inventory purchases, beginning balance	$10,500
		March Purchases 	$14,100
		Total Cash Payment 	$24,600
		Criteria for Collections on account :			January	February	March	Uncollectibles 
		Month of Sales -Same Month-% of Collectibles 	15%	Sales on Account 	$25,000	$30,000	$40,000	$2,850
		Month following Sale -% of Collectibles 	60%	Budgeted Inventory Purchases in March			23500
		Second Month following sale -% of Collectibles 	22%
		Uncollectibles -% of Collectibles 	3%	Pending 
		Criteria for Inventiory Payments -
		Month of Purchase -% of Payables	60%
		Month following Purchase -% of Collectibles 	40%
		S&P Enterprises
		Cash Budget
		For the Month of March
		Cash Balance ,March 1		$11,500	(Jan Cash receipt+Jan on account 1st Instalmnt.+January 2nd Instalmnt.) + (February Cash receipt+February on account 1st Instalmnt.

Managerial Accounting Assignment (Due: May 1, 2022 at 11:30 P.M. Managerial Accounting Assignment (Due: May 1, 2022 at 11:30 P.M. This is an excel assignment where we have to input the information...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment