Question

Help me finish the remaining sections. It's pretty self explanatory on here but i am busy with work so i am unable to finish it. The requirements and needed information are included on the pictures. I answered most of the sections but i need requirement 2 and requirement 3 still
Cardinal Design, Inc. is a Web site design and consulting firm. The firm uses a job order costing system in which each client is a different job. Cardinal Design assigns direct labor, licensing costs, and travel costs directly to each job. It allocates indirect costs to jobs based on a predetermined overhead allocation rate, computed as a percentage of direct labor costs At the beginning of 2018, managing partner Linda Eaton prepared the following budget estimates: (Click the icon to view the prepared budget.) In November 2018, Cardinal Design served several clients. Records for two clients appe here: 5 Click the icon to view the records for two clients.) Read the requirements Estimated Cost of Food Place and White Chocolates Jobs White Data Table Х Food Place Chocolates Direct Costs: Direct labor 6.250 hours 800 hrs. x 288 hrs. x Direct labor hours (professionals) Direct labor costs (professionals) Support staff salaries Computer leases Office supplies Office rent $ 1,800,000 587,000 48,000 Software licensing costs Travel costs 25,000 60.000 Total Direct Costs Allocated Indirect Costs: % x Print Done % x Total Costs Requirement 3. If Eaton wants to earn profits equal to 20% of service revenue, what fee should she charge each of these two clients? Food Place $ White Chocolates $ Choose from any list or enter any number in the input fields and then continue to the next question

Answer 1

If you like my explanation, please give a "thumbs up"

А B с D E F G K L 1 2 3 Labor cost per hour Labor cost per hour Labor cost per hour Direct labor costs/Direct labor hours 1800000/6250 288 4 5 6 7 587000 48000 H Requirement: 2 Cardinal Design Estimated cost of Food Place and White Chocolate Jobs Food Place White Chocolate Direct costs Direct labor 800 hours * 288 per hour 230400 500 hours * 288 per hour 144000 Software Licensing costs 5000 300 Travel costs 7000 0 Total direct costs 242400 144300 Indirect costs 230400*40% 92160 144000*40% 57600 Total job costs 334560 144300 8 Predetermined overhead rate Support staff salaries Computer lease payments Office supplies Office rent Total estimated indirect costs Direct labor cost Predetermined overhead rate 9 25000 60000 10 11 12 720000 1800000 40% 13 14 15 16 17 18 Requirement :3 19 418200 Food Place White Chocolate 20 180375 21 22 23 24 If profit is 20% of sales (x) sales Less: Profit Cost 25 100% x 20% x 80% x 26 x=cost/80% 27 Sheet105 Sheet106 Sheet107 Sheet108 Sheet109 Sheet109 Sheet110 Sheet111 Stats Ready

For calculation ref:

A B C D E F K 1 2 3 4 Labor cost per hour Labor cost per hour Labor cost per hour Direct labor costs/Direct labor hours 1800000/6250 =1800000/6250 5 6 7 H 1 J Requirement: 2 Cardinal Design Estimated cost of Food Place and White Chocolate Jobs Food Place White Chocolate Direct costs Direct labor 800 hours * 288 per hour =800*C4 500 hours * 288 per hour =500*C4 Software Licensing costs 5000 300 Travel costs 7000 0 Total direct costs ESUM(17:110) =SUM(17:J10) Indirect costs 230400*40% =17*C13 144000*40% =J8*C13 Total job costs =113+111 =J13+J11 Predetermined overhead rate Support staff salaries 587000 Computer lease payments 48000 Office supplies 25000 Office rent 60000 Total estimated indirect costs =SUM(C7:010) Direct labor cost 1800000 Predetermined overhead rate=C11/C12 8 9 10 11 12 13 14 15 16 17 Requirement:3 18 19 Food Place White Chocolate =115/(100%-20%) = 15/(100%-20%) 20 21 22 23 24 1 х If profit is 20% of sales (x) sales Less: Profit Cost 25 0.2 х 26 =124-125 х X=cost/80% 27 KI Sheet105 Sheet106 Sheet107 Sheet108 Sheet109 Sheet110 Sheet111 Stats Ready