Question

Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures:

 

Actual			Forecast			Additional Information
November	$600,000		January	$680,000		April forecast	$730,000
December	620,000		February	720,000
			March	740,000

 

Of the firm's sales, 40 percent are for cash and the remaining 60 percent are on credit. Of credit sales, 30 percent are paid in the month after sale and 70 percent are paid in the second month after the sale. Materials cost 30 percent of sales and are purchased and received each month in an amount sufficient to cover the following month's expected sales. Materials are paid for in the month after they are received. Labour expense is 50 percent of sales and is paid in the month of sales. Selling and administrative expense is 8 percent of sales and is also paid in the month of sales. Overhead is $35,000 in cash per month; Amortization expense is $12,000 per month. Taxes of $9,900 will be paid in January and dividends of $5,500 will be paid in March. Cash at the beginning of January is $120,000, and the minimum desired cash balance is $115,000.

 

a. Prepare a schedule of monthly cash receipts for January, February and March.

 

Jim Daniels Health Products Cash Receipts Schedule

November

December

January

February

March

April

Sales

$

$

$

$

$

$

Credit sales

Cash sales

Collections in the month   after credit sales

Collections two months   after credit sales

Total cash receipts

$

$

$

 

b. Prepare a schedule of  monthly cash payments for January, February and March.

 

Jim Daniels Health Products Cash Payments Schedule
	January	February	March
Payments for purchases	$	$	$
Labour expense
Selling and administrative expense
Overhead
Taxes
Dividends				Next > < Previous Sort answers by oldest Votes Oldest Newest Homework Answers Request Professional Answer Request Answer! We need at least 10 more requests to produce the answer. 0 / 10 The more requests, the faster the answer. Request! All students who have requested the answer will be notified once they are available. Know the answer? Add Answer to: Finance Question Your Answer: Post as a guest Your Name: What's your source? Earn Coins Log In Sign Up Post as anonymous Post Your Answer Similar Homework Help Questions Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores... Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures: Actual Forecast Additional Information November $240,000 January 260,000 February $320,000 April forecast 360,000 380,000 $370,000 December March Of the firm's sales, 40 percent are for cash and the... Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to... Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures: November December Forecast Additional Information $350,000 January $450,000 April forecast $510.ece 0.000 February 500.000 March 520,000 Of the firm's sales, 30 percent are for cash and the remaining... Finance question im Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures: ActualForecastAdditional Information  November$520,000January$600,000April forecast$650,000    December540,000February640,000March660,000 Of the firm's sales, 50 percent are for cash and the remaining 50 percent are on credit. Of credit sales, 40 percent are paid in the... (Chapters 1,4,5) Submitted 80.37/100 Total points awarded Help E Explanation Show my answers January through March.... (Chapters 1,4,5) Submitted 80.37/100 Total points awarded Help E Explanation Show my answers January through March. Following are actual and forecasted sales figures: Actual Forecast Additional Information November $440,000 January $520,000 April $570,000 forecast December 460,000 February 560,000 March 580,000 ed of the firm's sales, 40 percent are for cash and the remaining 60 percent are on credit. Of credit sales, 30 percent are paid in the month after sale and 70 percent are paid in the second month after... Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and nee... Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures:      Actual Forecast Additional Information November $460,000 January $540,000 April forecast $470,000 December 480,000 February 580,000 March 480,000 Of the firm’s sales, 50 percent are for cash and the... Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores... Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three month financial plan for January through March. Following are actual and forecasted sales figures: Actual Forecast November $440,000 January $520,000 December 460,000 February 560,000 March 580,000 Additional Information $570,000 forecast of the firm's sales, 40 percent are for cash and the...      Harry's Carryout Stores has eight locations, The firm wishes to expand by two more stores...      Harry's Carryout Stores has eight locations, The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures: Actual Forecast Additional Information November 360,000 January 440,000 April forecast December 380,000 February480,000 $420,000 March 430,000 Of the firm's sales, 50 percent are for cash and ther... please help Che Harry's Carryout Stores has eight locations. The firm wishes to expand by two... please help Che Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $240, 8 January $320,000 April forecast $360,000 December 260,00 February 360,000 March 370,000 of the firm's sales, 60 percent are... Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and... Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $240,000 January $320,000 April forecast $360,000 December 260,000 February 360,000 March 370,000 Of the firm's sales, 60 percent are for cash and the... Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do t... Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $240,000 January $320,000 April forecast $360,000 December 260,000 February 360,000 March 370,000 Of the firm's sales, 60 percent are for cash and the... ADVERTISEMENT Free Homework Help App Download From Google Play Scan Your Homework to Get Instant Free Answers Need Online Homework Help? Ask a Question Get Answers For Free Most questions answered within 3 hours. ADVERTISEMENT Share Your Knowledge Post an Article +5 Coins Post an Answer +5 Coins Post a Question with Answer +5 Coins ADVERTISEMENT Active Questions The Bahraini public budget experiences deficit in the last seven years, what are procedures are taken... You invested $30,000 in a mutual fund at the beginning of the year when the NAV... Would you expect the price elasticity of supply for guitars to be more inelastic in the... A snowmobile is originally at the point with position vector 30.1 m at 95.0° counterclockwise from... MAN3240 Organizational Behavior In one to two paragraphs 6.) How can understanding emotions make me more... Identify one individual who, in your opinion, is an excellent leader. List the qualities that this... For the data set shown​ below, complete parts​ (a) through​ (d) below. x 3 4 5... A university administrator working in student housing wants to determine if the percentage of students residing... 3). Describe human population growth that has occurred in the past 400 years. Use terms learned... A projectile is blue at a target. The distance from the point of impact to the... Given a 32 bit processor, with 2 MB of physical RAM split into 512 frames. What... What were the main rulings in the Supreme Court cases which are Morgan v. Virginia (1946)... ADVERTISEMENT DMCA About Contact Terms of Use Privacy Policy Academic Honesty Policy Homework Answer Scanner App © 2013-2022 ZuoTi.Pro user contributions licensed under cc by-sa 4.0