HCS 380 Seek Your Dream /uophelp.com HCS 380 Seek Your Dream /uophelp.com | Page 19

This Tutorial contains Excel Sheet which can be used to solve below mentioned Problem for any numbers / values
Complete the assigned exercises in WileyPLUS.
� Chapter 7- Excel Assignment( E7-8);
� Chapter 7- Excel Assignment( E7-14: Cash Budget)
Exercise 7-8
The following information pertains to Joyce Company. 1. Cash balance per bank, July 31, $ 7,419. 2. July bank service charge not recorded by the depositor $ 57. 3. Cash balance per books, July 31, $ 7,455. 4. Deposits in transit, July 31, $ 2,791.
5.
Note for $ 2,091 collected for Joyce Company in July by the bank, plus interest $ 55 less fee $ 39. The collection has not been recorded by Joyce Company, and no interest has been accrued. 6. Outstanding checks, July 31, $ 705. Exercise 7-14 Enright Company expects to have a cash balance of $ 63,550 on January 1, 2014. These are the relevant monthly budget data for the first two months of 2014. 1. Collections from customers: January $ 88,550, February $ 163,550. 2. Payments to suppliers: January $ 57,550, February $ 92,550.
3.
4.
Wages: January $ 30, 161, February $ 40, 161. Wages are paid in the month they are incurred. Administrative expenses: January $ 21,161, February $ 24,161. These costs include depreciation of $ 1,000 per month. All other costs are paid as incurred. Selling expenses: January $ 15, 161, February $ 20, 161. These costs
5. are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize