Enter a formula in cell B1 using the SUMPRODUCT function to calculate the total value of the current leases by multiplying the current monthly rents by the remaining months on each lease. Use the range names Rents and Leases.

Tiana daniels enterprise’s trial balance as at december 31, 2016 did not balance. on february 15, 2017 the following errors were detected: errorsi. water rates had been undercast by $2, 000.  ii. a cheque paid to yvonne walch of $2, 680 had been posted to the credit side of her account.  iii. discount received total of $1, 260 had been posted to the debit side of the discount allowed account as $1, 620.  iv. rent paid in the amount of $24, 000 had been posted to the credit of the rent received account.  v. wayne returned goods valuing $1, 680 to daniels enterprise but had been completely omitted from the books.    required: 1. prepare the journal entries to correct the errors.  (narrations required)                    14.5 marks  2.    prepare the suspense account showing clearly the original trial balance error.          8 marks

Harwood company uses a job-order costing system that applies overhead cost to jobs on the basis of machine-hours. the company's predetermined overhead rate of $2.50 per machine-hour was based on a cost formula that estimates $240,000 of total manufacturing overhead for an estimated activity level of 96,000 machine-hours. required: 1. assume that during the year the company works only 91,000 machine-hours and incurs the following costs in the manufacturing overhead and work in process accounts: compute the amount of overhead cost that would be applied to work in process for the year and make the entry in your t-accounts. 2a. compute the amount of underapplied or overapplied overhead for the year and show the balance in your manufacturing overhead t-account. 2b. prepare a journal entry to close the company's underapplied or overapplied overhead to cost of goods sold.

Imagine us is a startup that offers high definition 3d prenatal ultrasounds for high-end customers. the service process includes four activities that are conducted in the sequence described below. (the time required for each activity is shown in parentheses): activity 1: welcome a patient and explain the procedure. (20 minutes)activity 2: prep the patient (e.g., show them to the room, apply ultrasound gel). (17 minutes) (*your id number represents the amount of time needed to complete this task)activity 3: take images. (5 minutes)activity 4: discuss diagnostic with patient. (20 minutes)at each location there are employees (servers) s1, s2, and s3. the assignment of tasks to servers is the following: s1 does activities 1 and 2.s2 does activity 3.s3 does activity 4.a. what is the capacity of this process (in customers per hour)? b. suppose 3 patients arrive every hour on average. ignoring any “start of day” or “end of day” effects, what are the utilizations of all three servers (%)? c. suppose each activity can be done by any server and any server can do any set of activities. however, each activity is done by only one server. for example, a possible assignment includes: s1 does activity 1, s2 does activity 2, and s3 does activities 3 and 4. of course, the original assignment of servers to activities is also feasible. what is the maximum capacity of the process (in customers per hour)? d. now consider the capacity measures in (c) and (a), what is the percentage change? why can you improve capacity without using additional resources? (there is no free lunch, right? )note: for all hw assignments, show your process of getting the results. only providing the final answers is not acceptable and will get 0%. if necessary, use a separate sheet of paper to show your work.