BE12.1 - Using Excel to Determine Inventory Cost Per Unit Under Absorption Costing PROBLEM Landon is working on putting together the financials for his company's quarterly report. His company uses standard costs within its absorption costing system, and Landon needs to find the budgeted cost per unit in order to estimate COGS. Landon has provided the following cost information. \begin{tabular}{lr} Budgeted variable manufacturing cost per unit & $5.00 \\ Budgeted variable operating cost per unit & 3.00 \\ Budgeted fixed overhead costs & 30,000 \\ Budgeted fixed operating costs & 20,000 \\ Budgeted production in units & 5,000 \end{tabular} Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. How much cost should be capitalized to inventory for each unit produced? Cost per unit