Here are some hints for the tabs
Tab #4
4.05 and 4.06 – The variable selling and admin from last year are in Tab #2 in the Income Statement. If you go to Tab #2 and scroll up, you will see the variable selling expense PER UNIT and the variable admin expense PER UNIT.
Tab #12
12.03 – The ending work-in-process is 100% complete for direct materials because they told you in Tab #11 that the direct materials are added at the beginning of the period.
12.06 – You need 4 numbers. It will be the sum:
1. Beginning Direct Labor (given)
2. Beginning Manuf. Overhead (given)
3. Current Direct Labor Cost (given)
4. Current Manufacturing Overhead (not given, but it’s 50% of your Current Direct Labor Cost).
Tab #13
13.01 – Direct materials incurred is the lamp kits requisitioned from January 9th times the cost per lamp kit from January 5th.
13.03 – Manufacturing overhead applied is 50% of direct labor cost. So just take 50% of 13.02
Here are the most common ones:
Question 7.01. For this question, you have to start with the planned sales (given at the top) and the desired ending inventory. They tell you in the fact pattern that they want to decrease finished goods by 20%. If you look at the Balance Sheet (sheet #2) you will see that they had 3,000 items in finished goods last year. They want to decrease that number by 20% which would be 600. Therefore, the desired ending inventory is 2,400 (3,000 – 600).
8.02 is given on sheet #7. It’s the desired ending inventory of lamp kits.
9.01 is just the total factory overhead from 8.11 divided by the planned production.
For 9.03, you need 3 things to make a unit: Direct Materials (Lamp Kits), Direct Labor and Manufacturing Overhead. You already have all 3 numbers:
DM: From 8.05
DL: From 8.07
MO: From 9.01
9.08 is the ending lamp kits from 8.02 times the cost per lamp kit from 8.05.
9.09 is asking you about direct materials (lamp kits) USED in production. You need to follow the formula that’s there:
Beginning inventory = From Balance Sheet $8,000
Plus: Purchased = From 8.06
= Available for Sale
Less: Ending Inventory of Lamp Kits = From (8.02 X 8.05)
= Lamps Kits Used in Production
For 9.12, Cost of Goods available is your beginning finished goods inventory (9.07) + your current costs (DM, DL and MO). DM, DL and MO are 9.09, 9.10 and 9.11.
9.13 is the units left in finished goods inventory (desired ending finished goods from sheet #7) X cost per unit from 9.03.
For 10.05, take your purchases from sheet #8 (8.06) and then multiply it by the percentage they gave you on sheet #10 in the additional information (#2 of the additional information).
For 10.06, (depreciation) you need to multiply .006 times the answer from 4.11 (total fixed costs).
For 10.07, you need to add accounts payable (from Balance Sheet) plus 10.05 + DL + MO + Selling and Admin and then subtract the depreciation expense.
Project Tabs 15 & 16
Posted on: Monday, March 29, 2021 5:18:01 PM EDT
Hi everyone!
Here’s some help for 15 and 16:
15.01 is asking you for the price variance. You need to compare (Quantity Purchased X Actual Price) vs (Quantity Purchased X Standard Price).
On 15.02, the standard quantity allowed is 1 lamp kit for every lamp completed and shipped. You then compare that amount to the lamp kits that were requisitioned (used).
15.03 = For direct labor efficiency, they are supposed to make 4 lamps per hour. So to get the standard hours allowed you need to take the lamps completed and shipped and divide that number by 4.
For 1 5.04, you first need to calculate the total amount paid to the employees. You need to take the hours on Jan 17th times the rate. Then take the hours on Jan 30th times the rate. You need to add these two total to get the ACTUAL direct labor costs. Then to get the Budgeted amount you add the hours on Jan 17th to the hours on Jan 30th an you multiply times the standard rate. The standard rate is $2.40 per lamp. If they are supposed to make 4 per hours, then the standard rate is $2.40 X 4 = $9.60
16.01 = (Actual Hours Worked – Total Hours Allowed) X $1. We are multiplying by $1 because that is the variable overhead rate per hour. If the actual hours worked are greater than the total hours allowed, this variance will be unfavorable. If the actual hours worked are less than the total hours allowed, this variance will be favorable.
16.02 = (Actual Hours Worked X $1) versus Actual Variable Overhead. If the actual variable overhead is greater, then this variance will be unfavorable. If the actual variable overhead is less, then this variance will be favorable.
16.03 = (Expected Production – Actual Units Produced) X $10. If the expected production is greater than the actual production, this variance will be unfavorable. If the expected production is less than the actual production, this variance will be favorable.
16.04 = (Expected Production X $10) versus Actual Fixed Overhead. If the actual fixed overhead is greater, then this variance will be unfavorable. If the actual fixed overhead is less, then this variance will be favorable.