ACCOUNTING-Variable Costing: (spreadsheet assignment #3)

QUESTION

Variable Costing: (spreadsheet assignment #3)March:Beginning inventory = 2,500 units $26,500 ($10,000 variable)Production = 32,000 unitsSales = 31,000 units @ $50 eachVMC (DM, DL, and VOH) = $129,600FMC = $300,000VS/A costs = $124,000FS/A costs = $550,000April:Beginning inventory = ?Production = 33,000 unitsSales = 34,000 units @ $50 eachVMC (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 andApril. Prepare automated reports for both income methods for both months. A proper solutionwill include a separate input section (under a separate tab) in which only data items will beentered (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 theinformation above, your solution will be for these periods

ANSWER:

REQUEST HELP FROM A TUTOR