Attachment # 00001167 - ACC_6404_Accounting_Problem_Sheet.xlsx
ACC_6404_Accounting_Problem_Sheet.xlsx (201.57 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
***='11'!$H18Total Current Assetslabor and overhead. 1. Production Budget***='15'!$G36***='15'!$G462. Labor Costs are expected to increase by 5.00%.FirstTo keep records of the actual cost of a special order job, a Job Order Cost System has been developed.Direct Labor***='17'!$G30Payables of 12/31/x1 will have a cash impact in 20x2.)Projected Total Variable Cost Per Unit Production Costs:Total cost of Conversion this period (Round to two places, ##.###.##)4,150 figurines were requisitioned. LaborMaterial cost per unitWhat was the material usage variance for electrical components?***='11'!$H95***='11'!$H96Capital Decision MakingOn the following schedule develop the following figures:to 23.00% of sales. If that is to be achieved, what would be the sales in units in 20x2?The fixed OH volume (denominator) variance:When calculating projected increases round to SEVEN decimal places,$0.0000000.7. Fixed Administrative expenses are expected to increase by $10,000.Factor***=' 10 '!$J88***=' 4'!$D$28InventoryCost of Direct Labor Incurred in Manufacturing Job 2407Excess (Absorption Costing Operating Income - Variable Costing Operating Income)Purchases Total Liabilities and Stockholder's Equityin the molding department. The factory overhead is applied at a rate of 50% of direct labor dollars.Account Receivable (Sales last year not collected)***=' 4'!$D$39***=' 4'!$D$19Variable Overhead:per lamp (based on normal capacity of 25,000 lamps)Fixed AssetsThe material is added at the beginning of the process. The labor and overhead costs are assumed***='15'!$G64Selling Expenses:For the Year Ending December 31, 20x2***='17'!$G58sold to generated a net income of $240,000 after taxes?New selling price per lamp (Round up to two places, $###,###.## )3. Variable Overhead is expected to increase by 4.00%.Fixed Manufacturing Overhead in the Ending Inventory***='8'!$F34Purchases made and paid for in 20x2***='15'!$G71Breakeven sales in units (Round up to zero places, ###,### units)Work-in-Process - Ending***=' 9 '!$H$9420x1 Cost Predetermined Factory Overhead Rate based upon the budgeted***='17'!$G90PART 4.1Cost per equivalent unit of Material this period (Round to seven places, ###.#######)usable for 6 years, after which it would be inefficient, obsolete and would have to be disposed of at the Total cost in the Beginning Inventory (Round to two places, ##,###.##)New Selling Price (Round up to two places, $###,###.## )Stephanie CampanionyWhat is the contribution margin per can of soda? (rounded to five places, $#.#####)***=' 10 '!$J113Equivalent Units Material (Round to three places, ##.###.###) Total LiabilitiesThe 6,500 figurines that were in-process at the end of January were assumed to be 50.00% complete to***='15'!$G29***='8'!$F95Variable Manufacturing Unit Costweeks per year. A case of soda (24 cans) costs $5.76 and Big Al believes that a price of $.60 per per lamp***='17'!$G95***=' 10 '!$J100***='8'!$F12For 20x2 the selling price per lamp will be $45.00. What is the projected contribution margin and contribution Lamp Shades:Interest RateAdministrative Expenses***=' 9 '!$H$90Notes for Budgeting:If off the chart use 100%Accounts Payable (Purchases last year)Beginning Cash Balance***=' 20 '!$J99Contribution Margin Ratio (Round to seven places,% is two of those places ##.#####%)Work in ProcessTotal Labor Cost (Round to two places, $##.##)StandardsJanuary Electrical PartsJob Order Costing Section***=' 13'!$G73Variable Cost of Goods Sold***='17'!$G36***='11'!$H82Desired Ending Inventory ***='17'!$G31Molding Departmentper lamp (4 lamps/hr.)Fixed Administrative 20x2Total Cash OutflowsCost of Goods Available For SaleFixed Administrative***='22'!$J93Amount to be borrowed (if any)3,990 lamps were completed and shipped. All materials requisitioned were ***=' 20 '!$J28***=' 13'!$G63Process Costing - Weighted AverageTotal Purchases***='17'!$G45number Beginning Inventory, Finished Goods (Variable Costing)Contribution Margin per unit (Round to seven places, $##.#######)Expected increases for 20x2 ***='8'!$F$101 Less: Ending Inventory, Finished GoodsI See The LightTotal Production***=' 20 '!$J53 Electrical Parts Used In Production***='15'!$G86***='15'!$G80The variable OH spending variance:Variable Administrative (Round to two places, $##.##) number of units to be produced (Round to seven places, $##.#######)Cash Inflows:***=' 10 '!$J87Sales made and collected in 20x2***=' 4'!$D$26While normal spoilage is 5%, 2,220 units failed inspection in January. The units are inspected at the end of the process.***=' 4'!$D$16***=' 9 '!$H$82Campaniony***=' 9 '!$H$93 by 6.00%.50% of direct labor costs in the molding department.SC6032PART 6Direct Labor BudgetPayroll of 660 Direct Labor Hours @ $9.85 per hour.***='21'!$J132Note: Show favorable variances as negative numbers***='8'!$F81Operating Income, Variable CostingUnits Started this PeriodPurchased 4,150 figurines @ $9.25 per figurine.1. Material Costs are expected to increase by 2.00% .What was the budgeted fixed overhead?*****=' 4'!$D$41Accumulated Depreciation***='8'!$F63For 20x2 the selling price per lamp will be $45.00. The company would like to have a net income equalActual Variable Manufacturing Overhead***=' 9 '!$H39Total Accounted forProcess Costing - Weighted Average With Spoilage 3. Direct Labor BudgetWhat was the standard cost of a Lamp Shade?Month End Overhead Information20x2 Cost Rounded to 7 Decimal Places***='11'!$H71***='11'!$H72(Commission per unit) TotalGoods in-process as of January 1 were 3,200 figurines at a cost of $5,312.00. Of this amount, $1,856.00 was from Labor:Cash AvailableEquipmentNumberBig Al gives his worker's a one hour lunch and two fifteen minute breaks each day. He believes that aProduction Costs:***='11'!$H123that was used to determine the standard fixed overhead rate?40.00% complete as to labor and overhead.***='11'!$H124Variable***=' 9 '!$H17***=' 4'!$D$11 Variance Analysis***=' 4'!$B$27***='22'!$J119Factory Overhead Budget3. All other manufacturing and operating costs are paid for when incurred.What is the internal rate of return. Pick the closest interest rate from the tables on page 23.Cost per equivalent unit of Conversion (Round to seven places, ###.#######) (normal capacity of _________ lamps @ __ )How many Lamps were completed?Accounts Payable***=' 4'!$D$44MOLDING Projected Increase Find ***=' 10 '!$J112***=' 6'!$H19Mr. Smith, a consultant, has indicated that the Weighted Average method is appropriate our needs. He is concerned He has priced a machine at a national member only warehouse for $2,100. The machine should beWhat was the standard cost per lamp for the variable overhead?Fixed and Variable Cost Determinations ***=' 6'!$H36***=' 13'!$G84What was the standard cost per lamp for the fixed overhead?***='21'!$J47Fixed Costs:2- 20x2 Projected Variable Unit Cost per lamp.question which is marked correct. Correct 8. Cash Budget Electrical SetsThe computer is giving you part credit. Units to Account forL830Total Selling and Administrative (Round to two places, $##.##) ***='8'!$F15***='11'!$H108***=' 6'!$H77Needed for ProductionIf the company believes that the demand will be 27,500 units for the year. What selling priceWhat is the payback period in years? (rounded to two places, #.## years)Cost of Goods SoldIncrease (Fixed Manufacturing Overhead in the Ending Inventory-Fixed Manufacturing Overhead in the Beginning Inventory)***='22'!$J61To keep records of the actual cost of a job, a Job Order Cost System has been developed. Entries***='5'!$I32Total Factory Overhead (Round to two places, $##.##)Cost per sq. ft. $6Total cost of Material (Round to two places, ##.###.##)***='17'!$G72Total cost of one unit***='21'!$J124For the Period Ending December 31, 20x1Budgeted Number of Units to be ProducedFilecan would win him good will.Total Selling and Administrative Expenses:***='11'!$H69increasing the finished goods by 26.00% .During January, 25,500 units were started, $14,790.00 of materials and $43,506.00 of labor costs were incurred.Purchased 4,050 sets of electical components @ $1.20 per set.Materials Budget5. Fixed selling expenses are expected to be $35,000 in 20x2.Overhead is applied at the rate of 50% of the direct labor cost.Sales in units (Round up to zero places, ###,### units)General Information Ending Inventory of Electrical PartsFixed Selling the total fixed administrative expense.Cost of making one unit next year Job Order Costing the variable administrative expense per lamp.***='17'!$G28***='17'!$G29Actual Fixed OverheadJanuary 5 until the job was completed: Fixed Administrativeused or scrapped.Stephanie***='15'!$G75FIRSTActual Variable Overhead Cost per pieceup to the next complete unit. Furthuremore, to find the required sales in dollars it may be easier to find the {1.2} Cost ---- $600 correct based on the wrong area. Note if the area is corrected,120 sq ft, the cost would be wrong.Actual Fixed Manufacturing OverheadCurrent Liabilities 7. Budgeted Income StatementLastper lamp, rounded to two places, would generate a net income of $822,500? ***='8'!$F98Equivalent Units Conversion (Round to three places, ##.###.###)The I See The Light Company has a related company that produces the figurines. They use process costingSelling and Admin. BudgetSelling Expenses & Admin. ExpensesTotal Fixed AssetsProfit PlanningLabor Cost Per LampThe projected cost of a lamp is calculated based upon the projected increases or decreases toIf the time value of money is 12% per year what is the net present value? Use the tables on page 23.What was the total material price variance for the figurines purchased?Cost of Direct Material Incurred in Manufacturing Job 2407 Labor***='5'!$I30Desired Ending Inventory of Finished Goods (roundup to the next unit)Projected Cash BudgetTotal cost of Material this period (Round to two places, ##.###.##)PeriodsTotal Variable Cost Per UnitFinished Goods***=' 9 '!$H$92Lamp ShadeWidth 10 ftBudgeted Income Statementabout the number of units that failed inspection and the pricing of the good units completed.***=' 20 '!$J87 to be added uniformly throughout.Fixed Administrative 20x14,025 sets of electrical components were requisitioned. What was the material usage variance for figurines?***='7'!$E81***='8'!$F21FAQ 01Selected information for January is presented below. Note that the applied overhead rate wasProjected Total Fixed CostsWork-in-Process - BeginningFixed OverheadProductionFactory overhead per unitPhysical Flow of UnitsDirect Labor:***='11'!$H59 Total Assetswould sales in units have to be in 20x2 to reach the profit goal? Variable OverheadGross ProfitTotal FixedRaw MaterialVariable Administrative 20x2Abnormal spoilageFigurinesElectrical Sets***=' 4'!$D$32 Lamp Shades Used In ProductionCash Outflows:Present Value of Annuity $1.00 in Arrears Total Stockholder's EquityPART 5Mary correctly completed the material variances for the lamp shades and the overhead variences. PART 2Normal spoilage (Roundup to the next unit if needed)The company wants to maintain the same number of units in the beginning and ending inventories of***='15'!$G57Operating Income, AbsorptionWhat was the material price variance for the electrical components ?***='15'!$G18***='15'!$G94Total NeededOn January 1, 20x2, Division S began Job 1101 for the Client, THE BIG CHILDREN STORE. The Ending Inventory of Figurines4. The budgeted depreciation expense is equal to 0.6% of the fixed manufacturing, selling and administrative expenses. $40,320.00, when 22,000 units were sold. Use the High-Low method to calculate Less: Ending Inventory, Finished Goods (Variable Costing) Figurines Used In ProductionRound dollars to seven places, $##.#######Process Costing - First-In First-Outcold soda machine would be appreciated by his workers, and an appreciated worker is a good worker. Net ProfitCost per equivalent unit of Conversion this period (Round to seven places, ###.#######)How many cans of soda must be sold each year to breakeven? (Round up to zero places, ###,### cans)As of December 31, 20x1Cost per lamp:***='17'!$G100***=' 10 '!$J79FavorableUnit Cost Calculations***=' 4'!$D$14***='22'!$J135(Round to seven places, $##.#######){1.1} Area ----- 100 sq ft (wrong)Needed Minimum Balance***=' 6'!$H58Cost per equivalent unit of Material (Round to seven places, ###.#######)5. Minimum Cash Balance needed for 20x2, $170,000 .PART 4.2***=' 20 '!$J39PART 7***=' 10 '!$J27Round dollars to two places, $##.## Fixed Manufacturing Overhead***='11'!$H43Mr. Jones, a consultant, has indicated that FIFO process costing would produce more meaningful cost data. Less: Depreciation***=' 10 '!$J115***=' 20 '!$J64 FigurinesProjected Percent Increase 1- 20x2 Projected Variable Manufacturing Unit Cost of a lamp.Schedule of Fixed Costsused or scrapped, and are a cost of normal processing.so that the new contribution margin per unit is equal to last year's contribution margin per unit?Retained Earningsdifferences.Total cost of Conversion (Round to two places, ##.###.##)Electrical Parts***=' 13'!$G107RateAll figurines in January passed inspection.Complete the following budgetsVariable Cost of Goods Sold - Assume FIFO (First-In, First-Out)dump. Big Al believes that 10 cans a day will be purchased. The plant is open five days a week, 50 InterestGiven:***='17'!$G83Production BudgetSales 4. Factory Overhead Budget Fixed Selling3- 20x2 Projected Fixed Costs.3,990 lamp shades were requisitionedProjected Variable Manufacturing Cost Per Unit***=' 9 '!$H68Round to six places, $##.######Total Manufacturing OverheadProjected Balance Sheet Electrical Parts***='5'!$I7620x2 Cost Rounded to 2 Decimal PlacesCost Volume Relationships -***=' 13'!$G41number of units and then multiply by the selling price per unit. Available for UseBudgeted Cash Balance before financingAnnual incremental cash inflows from the soda machine? (rounded to two places, $#.##)4. Fixed Overhead is expected to increase to $285,000.The company has requested that you prepare a master budget for the year. This budget is to be usedOther Manufacturing Costs6. Variable selling expenses (measured on a per lamp basis) are expected to increase Special order lamps are manufactured in division S. Because of the precise nature of the process a***='22'!$J144 Variable Overhead:***=' 10 '!$J118***='5'!$I52Variable Factory Overhead:8. Variable administrative expenses (measured on a per lamp basis) are expected to for planning and control of operations and should be composed of:LASTLength 12 ft***='8'!$F23Fixed Factory OverheadCost of the units transferred, material and convesion (Round to two places, $###,###.## )Selling and AdministrativeBig Al is about to begin work on the budget for 20x2 and they have requested that you prepare an analysisI See The Light, IncWhat was the direct labor rate variance?Standard Job Order Costing -SalesWhat was the direct labor efficiency variance ?Total transferred out***=' 13'!$G52If the company believed that it could only sell 25,000 lamps, what would the new selling price have to be Budgeted Operating Income Using Direct Costing***='17'!$G67The total material price variance for the lamp shades purchased:Budgeted Fixed OverheadCost of the ending inventory, material and convesion (Round to two places, $###,###.## )***=' 4'!$D$13For 20x2 the selling price per lamp will be $45.00. How many lamps must be sold to breakeven? job called for 4,000 customized lamps. The following set of transactions occurred from***='8'!$F43while entries are made to the accounting system at standard. Variance analysis is used to analyze the 6404Cost of the abnormal spoilage (Round to two places, $###,###.## )Fixed Overhead:For 20x2 the selling price per lamp will be $45.00 and the effective tax rate is 40%. How many units must be ***=' 9 '!$H$83***='17'!$G76 5. Selling and Administrative BudgetTotal cost to account for (Round to two places, ##.###.##)***='18'!$H99I SEE THE LIGHTPART 1Note: Remember, that we cannot sell part of a lamp, therefore to find the number of units you have to roundCurrent AssetsBeginning Inventory, Finished Goods The total variable administrative expenses for 20x0 were $40,320.00, whenPayroll of 610 Direct Labor Hours @ $9.60 per hour.Sales Collections:** Fixed overhead is based on expected production of ##### customized lamps each month. PurchasedFixed Manufacturing Overhead in the Beginning Inventorystandard cost system has been developed. The following standards are used for the special orders: 2. Materials BudgetStudentTotal Variable Factory Overhead (Round to two places, $##.##)Cash Budget$54.00 per lamp.PART 4.32. 80.00% of material purchases will be paid during the year, the remaining portion will be paid in Januay or February. Number of Units to be Produced121119Planned Sales Overhead 22,000 units were sold. Use the High-Low method to calculateVariable Cost of making one unit next year - used to calculate the Ending Inventory of Finished GoodsProjected Variable Manufacturing Unit Cost***='21'!$J97Schedule of Projected Costs Figurines: to the same screen that the project was downloaded from: Contribution Margin increase by 2.00%. The total administrative expenses for 20x0 were***=' 9 '!$H$80 Less: Beginning Inventory Beginning InventoryPurchased 4,000 lamp shades @ $6.60 per set.***='21'!$J82***=' 4'!$B$43 Cost of Purchases (Round to two places, $##.##)Variable Factory overhead per unit 6. Cost of Goods Sold Budget1. 15.00% of sales for the year are made in November and December. Since our customers have 60 day termsOn January 1, 20x2, Division S began Job 2407 for the Client, THE BIG CHILDREN STORE. TheBudgeted Cash Balance***='11'!$H112***='11'!$H122***=' 10 '!$J120***=' 13'!$G112raw materials added, $2,304.00 for labor and $1,152.00 for overhead. These 3,200 figurines were assumed to be current costs. The present costs to manufacture one lamp are:Division N has decided to develop its budget based upon projected sales of 33,000 lamps at are made to the Job Order System at actual cost (overhead is applied based on actual labor hours)margin ratio for each lamp sold?What is the estimated annual sales in cans of soda?Variable Selling (Round to two places, $##.##) Variable Selling***='8'!$F132.3.4.5.6.7.Common Stock Total Materials:based on the following assumptions.***='17'!$G49Stockholder's EquityVariable Administrative 20x1***='18'!$H84Fixed***=' 13'!$G29 Total Variable Production CostsUnfavorable***='18'!$H94 those funds will be collected be collected in January and February.Cost of manufacturing one lampWhat was the monthly expected production of customized lamps***='22'!$J37Budgetswork-in-process, and electrical parts while increasing the figurines inventory to 675 pieces andThe variable overhead efficiency variance:SC6032.xls or SC6032.xlsx Materials:***=' 13'!$G94***=' 13'!$G28***=' 13'!$G74Net Operating Income***='22'!$J76Her work is correct however, in reviewing her work the standards were crossed out. CashFor 20x2 the selling price per lamp will be $45.00. The desired net income in 20x2 is $259,500 . What Lamp ShadesTotal variable manufacturing cost of one unit1. Variable Factory Overhead Cost Per Unit***=' 4'!$D$15Cost of Manufacturing Overhead Applied to Job 2407***=' 4'!$D$45Projected Income StatementAssume actual cash receipts and disbursements will follow the pattern below: (Note: Receivables and ***=' 9 '!$H48Month of January***='18'!$H104PART 3 Stephanie, when you are ready to have your work graded you will upload this file ***=' 9 '!$H$91When I upload it, the results show that I have an answer wrong, yet that answer is needed for another Accounts ReceivableCost of Goods AvailableCost of Goods Sold Total Variable CostsThe fixed OH spending variance: Budgeted Fixed Cost Per Unit (Round to 7 decimals #.#######)

ACC 6404 Accounting Problem Worksheet Solution

Question # 00013464 Posted By: vikas Updated on: 04/25/2014 04:01 PM Due on: 05/12/2014
Subject Accounting Topic Accounting Tutorials:
Question
Dot Image
Process Costing - Weighted Average With Spoilage
Mr. Smith, a consultant, has indicated that the Weighted Average method is appropriate our needs. He is concerned
about the number of units that failed inspection and the pricing of the good units completed.

General Information

The I See The Light Company has a related company that produces the figurines. They use process costing
in the molding department. The factory overhead is applied at a rate of 50% of direct labor dollars.
The material is added at the beginning of the process. The labor and overhead costs are assumed
to be added uniformly throughout.





Month of January

Selected information for January is presented below. Note that the applied overhead rate was
50% of direct labor costs in the molding department.


Molding Department

Goods in-process as of January 1 were 3,200 figurines at a cost of $5,312.00. Of this amount, $1,856.00 was from
raw materials added, $2,304.00 for labor and $1,152.00 for overhead. These 3,200 figurines were assumed to be
40.00% complete as to labor and overhead.

During January, 25,500 units were started, $14,790.00 of materials and $43,506.00 of labor costs were incurred.

The 6,500 figurines that were in-process at the end of January were assumed to be 50.00% complete to
labor and overhead.

While normal spoilage is 5%, 2,220 units failed inspection in January. The units are inspected at the end of the process.

Dot Image
Tutorials for this Question
  1. Tutorial # 00013033 Posted By: vikas Posted on: 04/25/2014 04:02 PM
    Puchased By: 4
    Tutorial Preview
    The solution of ACC 6404 Accounting Problem Worksheet Solution...
    Attachments
    ACC_6404_Accounting_Problem.xlsx (202.92 KB)
Whatsapp Lisa