Solve on Excel if possible!

a. Enter the journal entry for the purchases/receivings (by receipt).

b. Enter the journal entry for the direct materials requisitions (by job)

c. Prepare the journal entry for factory payroll.

d. Enter the journal entry for direct labor. Job 101 required 5 hours of labor. Job 102 required 10 hours of labor (by job) (hint: compute the average rate).

e. 15 grams of gold went to indirect materials. Prepare the journal entry.

f. 75 hours of labor went to indirect labor. Prepare the journal entry.

g. Overhead is applied at a rate of 70% of direct materials AND direct labor COSTS. Show the journal entries. (by job)

h. Show the journal entry for the completion for each job.

i. Assume the company has a 50% markup. What is the price of each job?

j. Show Sales, Cost of Goods Sold, and Gross Profit in income statement format for the two jobs (by job)?

Basic job Costing (50 points) - Our company makes customized jewelry - Customer 101 orders a ring (job 101). It requires 2.5 grams of 14k gold, 1 diamond and 1 ruby. Customer 102 orders a pendant (job 102). It requires 2 grams of 14 k gold, and 2 rubies. Purchasing buys 1,000 grams of 14k gold for $25,000. 10 diamonds for $40,000, and 10 rubies for $18,000. For the month, the company had factory labor costs of $200,000 and 10,000 hours