Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

the format is the second picture provided but please use format in excel and please show formulas and cell references, thanks. Your taco truck is

image text in transcribed
image text in transcribed
the format is the second picture provided but please use format in excel and please show formulas and cell references, thanks.
Your taco truck is testing out producing tortillas for distribution to upscale grocery stores. Currently, you have been producing and distributing tortillas for a 3 month testing period. It is now the fourth month, and your team must perform an analysis to determine what changes are necessay moving forward. Your truck has two direct-cost categories: direct materials and direct labor and allocates fixed overhead to products on the basis of standard direct labor-hours. The following is some budget data your team put together prior to starting tortilla production. The following information has been compiled for the last three months of your tortilla adventure: Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Requirements 1 What is the denominator level used for allocating variable overhead? (That is, for how many direct labor-hours is your truck budgeting?) 2 Prepare a variance analysis of variable overhead. a. Use the ABS function when calculating variances, and use the drop-down selections for F (favorable) or U (unfavorable) when describing the variances. Saving & Submitting Solution 1 Save file to desktop. 2 Upload and submit your file to be graded. a. Navigate back to the assignments page in Canvas b. Click the assignment for Taco Truck Round-Up FOH c. Attach your file d. Click Submit 1. What is the denominator level used for allocating variable overhead? (That is, for how many direct labor-hours is your truck budgeting?) (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) hours 2. Prepare a variance analysis of variable overhead. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Use cell references from prior calculations, if applicable.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SEO Competitor Audit Journal

Authors: Nelz Plummer

1st Edition

B09DDWJGRC, 979-8459748123

More Books

Students also viewed these Accounting questions