E3A2 Month3 JanuaryFebruaryMarchSales6-Month averageBQfx$81,000.00$80,000.00$88,000.00$92,000.00$110,000.00$108,000.0056 April7 May8 June910111213 $500 Fixed Fee, 2% commission14 $1000 Fixed Fee, 1% commission15 $2000 Fixed Fee, 0.5% commission16D20010050EFFixed fee Guest count Variable expenxe Total expense Cost%500480050051205005006500496050051405005300GH PDo Chapter 8 question 2 (Tutti)Skip question 2aCreate a new column, "Guest Count", 4800, 5120, 5006, 4960, 5140, 5300 for months JanFormat dollar values to currency and percentage values to percentagesUsing Scenario Manager, create a Scenario Summary (worksheet) with the following scen$500 Fixed Fee, 2% commission$1000 Fixed Fee, 1% commission$2000 Fixed Fee, 0.5% commissionWhich scenario will result in the lowest 6-month average consultant cost percentage?Create a Scenario Summary (worksheet) with the following scenarios:10% increase in Guest Count, $1000 Fixed Fee, 2% commission10% increase in Guest Count, $2000 Fixed Fee, 1% commission10% increase in Guest Count, $4000 Fixed Fee, 0.5% commissionWhich scenario will result in the lowest 6-month average consultant cost percentage?RSTUS69000

Step 1: Select the "Sales", "Fixed fee", "Variable expense", and "Total expense" columns.…

Answered: Which scenario will result in the…

Business

Accounting

Which scenario will result in the lowest 6-month average consultant cost percentage?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Overallocated manufacturing overhead results when Question 37 options: estimated overhead is less than actual overhead. actual overhead is less than allocated overhead. production is less than last year. actual overhead is less than expected.
Give an example of how, under absorption costing, operating income could fall even though the unit sales level rises.
This is the length of time it takes to initiate and complete a finished product. O a. Fiscal year O b. Accounting year c. Production cycle Od. Short-term QUESTION 21 Costs that remain constant even with changes in production level. O a. Variable costs O b. Start-up costs O c. Semi-variable costs O d. Fixed costs QUESTION 22 The challenge of budgeting is to determine what will change and what will stay the same. O True False QUESTION 23 The numbers on tax returns (cash basis) are the same as the number we use to manage a department (accrual basis). O True O False QUESTION 24 A pattern of change over several time periods which can help us make estimates for the future is a. a gap. Ob. a fixed cost. Oc. a transformation. d. a trend.
Discuss two advantages and two disadvantages of a standard costing system in which the standarddirect labor rates per hour are not changed during the year to reflect events such as a new laborcontract.
Why would staff costs increase with increase in revenue?
Select all that were the source for the Indirect Costs favorable efficiency variance. a. Actual indirect costs per direct labor hour was less than budgeted indirect cost per direct labor hour. b. Actual indirect costs per direct labor hour was greater than budgeted indirect cost per direct labor hour. c. Actual number of jobs completed was less than budgeted number of jobs. d. Actual number of jobs completed was greater than budgeted number of jobs. e. Actual number of direct labor hours per job was less than budgeted direct labor hours per job. f. Actual number of direct labor hours per job was greater than budgeted direct labor hours par job. QUESTION 5 Select all that were the source for the Sales Activity favorable variance. a. Actual number of units completed was greater than budgeted number of units. b. Actual selling price per unit was less than budgeted. c. Actual number of units completed was less than budgeted number of units. d. Actual selling price per unit was greater than…
Overtime long time periods of several years, supervisory labor costs will tend to behave as: O A. Linear variable costs B. Step fixed costs C. Fixed costs O D. Semi - variable costs
PLEASE USE THIS TIME TO ANSWER THIS. AYAW NA PAGHULAT UG DEADLINE, TOMORROW IS ANOTHER DAY. PLEASE DEFINE AND GIVE THE FORMULA OF THE FOLLOWING (IF THERE IS ANY): PLEASE ANSWER HERE DIRECTLY 1. absorption costing 2. activity bases (drivers) 3. break-even polnt 4. contributlon margin 5. contributlon margin ratlo 6. cost behavlor 7. cost-volume-profit analysls 8. cost-volume-profit chart
Find the values of the missing items (a) through (x). Assume the actual sales volume equals actual production volume. Marketing and Administrative Sales Price Variance Variance Units Sales Revenue Less: Variable Manufacturing Costs Variable marketing and administrative costs Contribution margin Fixed manufacturing costs Fixed marketing and administrative costs Operating Profit PreviousNext Reported income statement (based on actual sales volume) Manufacturing variance (a) (g) (n) (q) (r) (t) $4,320 $3,600 (0) $1,800 U $ 400 F (u) (p) (s) (v) (w) $3,600 F (X) $3,600 F Flexible Budget (based on actual sales volume (b) (h) (m) Sales Activity Variance 4,000 F (1) $19,200 (i) $4,800 $800 U $12,000 (k) $3,000 $4,000 (1) Master Budget (based on budgeted sales volume) 20,000 $30,000 (c) (d) (e) (f) $16,000 $10,000
In detail discuss what are the advantages and disadvantages of using FIFO for process costing. In periods when costs are increasing how will FIFO affect reported net income? What about in periods of declining costs? Explain.
Which one is the correct answer?
prepare an income statement for last year using variable costing