Variable Costing: (spreadsheet assignment #3)March: Beginning inventory = 2,500 units $26,500 ($10,000 variable)Production = 32,000 units Sales
Question:
Variable Costing: (spreadsheet assignment #3)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,600FMC = $300,000VS/A costs = $124,000FS/A costs = $550,000April:Beginning inventory = ?Production = 33,000 units Sales = 34,000 units @ $50 each VMC (DM, DL, and VOH) = $133,650FMC = $300,000VS/A costs = $126,000FS/A costs = $550,000Required: Variable costing income and full-absorption costing income for both March and April. Prepare automated reports for 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 been tered (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 an output 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.
Cost Management Measuring Monitoring and Motivating Performance
ISBN: 978-0470769423
2nd edition
Authors: Leslie G. Eldenburg, Susan K. Wolcott