Reference no: EM13859257

Process costing:

LSW Co. uses a process costing system to account for manufacturing costs. The following data pertains to the period just ended:

	Direct Material Costs	Conversion Costs
Beg. Inv.	$5,000	$3,000
Current
Production	96,000	58,000

The beginning inventory consisted of 2,500 units of partially complete products that were 80% complete in material costs and 75% complete in conversion costs. Production on 48,000 units was begun during the period, and of those, 3,000 were incomplete at the end of the period. Those units in ending inventory were 30% complete in material costs and 40% complete in conversion costs.

Required:

Using Excel or some other spreadsheet software, you need to develop an automatic process costing system based on the FIFO method that will calculate LSW's ending inventory and cost of goods manufactured for every period. To do this, you will need to label a tab on a spreadsheet "INPUT." On this sheet, the inputs that change every period will be entered. IMPORTANT: the input sheet has data points only. No calculations of any sort should be on the input sheet. For example, the number of products started, the number of units in ending inventory, the percentage of completion with respect to materials, the material costs in beginning inventory are all examples of data points. You then need to label another tab "Cost of Production Report" or "OUTPUT." On this tab, you will perform all calculations for the current period by linking the data from the INPUT tab. In this manner, for every subsequent period, one would only have to update the information under the INPUT tab and the OUTPUT sheet would automatically calculate the correct EI balance and Cost of Goods Manufactured (HINT: there should not be any "hard" numbers on the OUTPUT sheet). 

Standard Costing: 

ACTUAL RESULTS
Total overhead costs	$483,500
Variable overhead costs	$185,000
Fixed overhead costs incurred	$298,500
Number of products produced	11,900 units
Direct labor costs	$104,703 (10,265 hours @ $10.20)
Direct material costs	$599,841 (120,450 lbs. @$4.98/lb.)
STANDARDS	Per unit/DLH
Direct materials	10 pounds @ $5 per pound
Direct labor	1 DLH @ $10/DLH
Variable overhead rate	$15 per allowed DLH
Fixed overhead rate	$25 per allowed DLH
Total overhead rate	$40 per allowed DLH
Normal activity level	12,000 units
Fixed OverheadEstimate	$300,000

Required:

Using Excel or some other spreadsheet software, you need to develop an automatic standard costing system that will calculate JCL's variances for every period. To do this, you will need to label a tab on a spreadsheet "INPUT." On this sheet, the inputs that change every period will be entered. IMPORTANT: the input sheet has data points only. No calculations of any sort should be on the input sheet. For example, the actual production for the period, the actual per unit cost for materials, the actual labor hours for the period, the actual variable overhead costs are all examples of data points. This sheet would be accessed every period and updated as these inputs change.

You then need to label another tab "STANDARDS." On this tab, you will put all the standards JCL uses to gauge their performance as well as the expected level of activity. This sheet is accessed periodically as JCL re-visits and revises their standards. This would probably not happen every period.

You then need to label another tab "VARIANCES" or "OUTPUT." No hard numbers should go on this sheet. It should perform all variance calculations for the current period by linking the data from the INPUT tab and the STANDARDS tab. In this manner, for every subsequent period, one would only have to update the information under the INPUT tab (and, less frequently, the STANDARDS tab,) and the OUTPUT sheet would automatically calculate the variances.

Variable Costing:

March:
Beginning inventory= 2,500 units $26,500 ($10,000 variable)
Production= 32,000 units
Sales = 31,000 units @ $50 each
VMC (DM, DL, and VOH) = $129,600
FMC = $300,000
VS/A costs = $124,000
FS/A costs = $550,000

April:

Beginning inventory = ?
Production = 33,000 units
Sales = 34,000 units @ $50 each
VMC (DM, DL, and VOH) = $133,650
FMC = $300,000
VS/A costs = $126,000
FS/A costs = $550,000

Required:

Variable costing income and full-absorption costingincome for both March and April.Prepare automated reportsfor both income methods for both months. A proper solution will include a separate input section (under a separate tab) in which only data items will be entered (you may use one input tab for both months). In a separate section (under another tab), you should link items from the input tab to anoutput section that contains the income reports (you may use one section for both variable and full-absorption costing income). Using the information above, your solution will be for these periods.