Dimovelis Foivos Prokopios - Excel (Product Activation Failed) F Sign in Share Comma 23 Normal 22 Conditional Formal as Bad Formatting Table" Good Normal Neutral Insert Delete Formal AutoSum Fill- Clear- Sort & Find & Filter Select Number Styles Cells Editing File Home Insert Page Layout Formulas Data Review View Tell me what you want to do... Cut Calibri 11 - A A Wrap Text General Copy Paste BIU- = = = ** Merge & Center -% Formal Painter Clipboard Font Alignment F17 A B D E F G H J K L M N 1 Hammer Inc. Company is a merchandising company that sells a single product. The company's sales in units for Quarter 3 of 2021 were as follows: August 2 3 Sales 4 July 70.000 61.000 September 62.000 5 They predict that Sales will increase by 4% in 2022. Units are sold for $11.50 each. One fourth of all sales are paid for in the month of sale and the 6 balance are paid for in the following month. Accounts receivable at 30 June 2022 is predicted to total $450,000. 7 8 Merchandise is purchased for $6 per unit. No beginning or ending inventories are kept. Half of the purchases are paid for in the month of the 9 purchase and the remainder are paid for in the month following purchase. Accounts payable at 30 June 2022 is predicted to be $290,000. 10 Selling and administrative expenses are expected to total $105,000 each month. And it includes 15,000 of Depreciation related to their cars. 11 Overhead is 150,000 per quarter and it includes 30,000 of Depreciation. It is spread evenly throughout the months. 12 Labor is 100,000 per month paid cash each month. 13 They plan to take a loan on August 1st 2022 for $50,000, interest of 9%, which is paid every month. 14 Cash at 30 June 2022 is predicted to total $50,000. A payment of $200,000 for purchase of equipment is scheduled for August, and a dividend of 15 $100,000 is to be paid in September 2022. 16 17 Required: 18 a. Prepare a cash budget for Hammer Inc. for the months July, August and September 2022. 19 b. Give your recommendations to Hammer Inc. regarding their cash situation (be very specific using actual numbers and relevant recommendations only for them) 20 Questions not related to the information above: 21 c. What is the difference between cash and profit (give some examples in order to answer the question)? 22 d. Which is the first budget that we start with, and which is the most important budget, in a master-budget? Problem 1 Problemn 2 | Problem 3 Ready Points 55 10 10 10 +130% 5:34 x 19C. . ENG 11/5/2022