Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please share the excel file if possible. Prepare all Fixed Manufacturing Overhead variances (FMOH Spending Variance. FMOH Production Volume Variance, FMOH Flexible Budget Variance. Over-applied
Please share the excel file if possible.
Prepare all Fixed Manufacturing Overhead variances (FMOH Spending Variance. FMOH Production Volume Variance, FMOH Flexible Budget Variance. Over-applied or Under- applied FMOH). Karibu Company produces a single product . The company has developed the following standards for one unit of output for the fiscal year 2018 The company uses machine hours to allocate both variable and fixed factory overhead to production. The company has 10,000 machine hours available The company is planning to produce and sell 10,000 units @ $100 each Budgeted sales for 2018 is based on an estimated market share of 10% Standard cost per unit of output: Item Direct Materials: Direct Labor: Variable MOH: Total Fixed MOH costs for the period Cost per Input 3.0 lbs. @ $4.0/16 2.0 hours @ $14.0/hour 1.0 Machine Hour @ $8.0/M.Hr $160.000 Cost per Unit $12/unit $28 / unit $8/ unit During 2018, the company used 6,000 machine hours to produce 8.000 units. All production was sold at $110 per unit The actual industry sales were 140,000 units During 2018, the company purchased 50,000 pounds of raw material @ $3.5 per pound Actual costs are as follows: Direct Material: 4 pounds @ $3.5/pound Direct Labor: 18,000 hours @ $12/ hour Variable MOH: $82,000 Fixed MOH: $170,000 To be submitted in the MS Excel Sheet Provided in the Excel File Required: Prepare an income statement for the static budget, flexible budget, and actual results. Prepare all Revenue variances (Sales Price Variance, Sales Volume Variance, Market Size Variance, Market Share Variance) Prepare all Direct Material variances (DM Price Variance, DM Purchase Price Variance, DM Efficiency Variance, DM Pure Price Variance, DM Combined Price Efficiency Variance, DM Flexible Budget Variance) Prepare all Direct Labour variances (DL Rate Variance. DL Efficiency Variance, DLFlexible Budget Variance) Prepare all Variable Manufacturing Overhead variances (VMOH Spending Variance, VMOH Efficiency Variance, VMOH Flexible Budget Variance, Over-applied or Under- applied VMOH)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started