Gabriel created the table above to help him organize financial information on the projected results of increased marketing campaigns for the swimsuit line. A change in marketing expense will change the number of units sold. Please refer to the table above when answering the questions below.
-Gabriel considers whether the average salary input item should be a changing cell. Although the average salary will change to $39,100 next year, it will not vary from that number for any of the five scenario options. Why would you recommend NOT making salary a changing cell?
Definitions:
Standard Price
A pre-determined cost assigned to goods and services, used as a benchmark in budgeting and variance analysis.
Pounds
A unit of weight commonly used in the British imperial and United States customary measurement systems.
Direct Materials Price Variance
The difference between the actual cost of direct materials used in production and the expected (or standard) cost of those materials.
Per-unit Standards
Benchmarks or norms for the cost or quantity of materials, labor, and overhead required to produce one unit of product, used for budgeting and performance evaluation.
Q3: To compare scenarios, you can create a
Q7: What was the major weakness of the
Q23: The FIND function is case sensitive, so
Q33: You use a _ when you want
Q46: What was the largest commercial enterprise of
Q106: What played a key role in stimulating
Q117: A _ worksheet usually contains the workbook
Q123: You can change the calculation used in
Q123: Additional money owed at the end of
Q142: There are three steps to troubleshoot an