Prepare a personal budget for one month in the blank worksheet named Budget. Be sure to think through your sources of income and expenses. Be as detailed as you wish; but include cells that calculate the following: total income (which calculates the sum of all income sources), total expenses (which calculates the sum of all expenses), and monthly savings (which calculates the difference between the total income and expenses). After completing your budget, complete the tasks to create named ranges that reference the important cells outlined above. Task # Points Task Description 5
1 5 Ceate a named range caled, Income that references the cel that calculates the total Income in your budget
2 5 Create a named rage called, Expenses" that refeences the cell ht calculaes the total expenses in your budget.
3 10 Create a named range called, "Savings" that references the cell that calculates the monthly savings in your budget. The savings calculation should be the difference between the total income and total expenses in your budget. Be sure to reference the named ranges for income and expenses in your calculations.

University car wash built a deluxe car wash across the street from campus. the new machines cost $219,000 including installation. the company estimates that the equipment will have a residual value of $19,500. university car wash also estimates it will use the machine for six years or about 12,500 total hours. actual use per year was as follows: year hours used 1 3,100 2 1,100 3 1,200 4 2,800 5 2,600 6 1,200 prepare a depreciation schedule for six years using the following methods: 1. straight-line. 2. double-declining-balance. 3. activity-based.

The following pertains to smoke, inc.’s investment in debt securities: on december 31, year 3, smoke reclassified a security acquired during the year for $70,000. it had a $50,000 fair value when it was reclassified from trading to available-for-sale. an available-for-sale security costing $75,000, written down to $30,000 in year 2 because of an other-than-temporary impairment of fair value, had a $60,000 fair value on december 31, year 3. what is the net effect of the above items on smoke’s net income for the year ended december 31, year 3?

Laval produces lamps and home lighting fixtures. its most popular product is a brushed aluminum desk lamp. this lamp is made from components shaped in the fabricating department and assembled in the assembly department. information related to the 22,000 desk lamps produced annually follows. direct materials $280,000direct labor fabricating department (8,000 dlh × $24 per dlh) $192,000assembly department (16,600 dlh × $26 per dlh) $431,600machine hours fabricating department $15,200mhassembly department $20,850mhexpected overhead cost and related data for the two production departments follow. fabricating assemblydirect labor hours 150,000dlh 295,000dlhmachine hours 161,000mh 128,000mhoverhead cost $400,000 430,000required1. determine the plantwide overhead rate for laval using direct labor hours as a base.2. determine the total manufacturing cost per unit for the aluminum desk lamp using the plantwide overhead rate.3. compute departmental overhead rates based on machine hours in the fabricating department and direct labor hours in the assembly department.4. use departmental overhead rates from requirement 3 to determine the total manufacturing cost per unit for the aluminum desk lamps.