| Part 2 | ||||||||
| Communications Unlimited provides support services to its clients. | ||||||||
| This company expects to earn an annual return on the assets invested at a rate of: | 20% | |||||||
| The company has the following amount invested in the business: | $8,000,000 | |||||||
| The annual budgeted costs for next year are: | ||||||||
| Variable costs | Fixed costs | |||||||
| Support Services | $600,000 | 1,900,000 | ||||||
| The annual budgeted hours for next year are: | ||||||||
| Consulting services | 60,000 | hours | ||||||
| Required: | You must use cell references for all calculations. | |||||||
| 5. Determine the markup on total costs in percentage terms. | ||||||||
| 6. Determine the total cost per hour. | ||||||||
| 7. Determine the revenue per hour that will be charged if total costs is the basis for markup. | ||||||||
| 8. Explain why answers 2-4 in comparison to 5-7 are the same or different. | ||||||||
| 9. Discuss the advantages and disadvantages of using a cost-based pricing model. | ||||||||
| You need to include an outside reference that supports your discussion on advantages and disadvantages of using a cost-based pricing model. | ||||||||
| Make sure you include the reference in APA style. Enter your response in the textbox below. | ||||||||
In: Accounting
Your Corporation has received a request for a special order of 9,500 units of product AB1 for $54.00 each. The normal selling price of this product is $60.99 each, but the units would need to be modified slightly for the customer. The normal unit product cost of product AB1 is computed as follows:
| Unit product costs, current | ||||
| Direct Materials | $ 19.50 | |||
| Direct Labor | $ 8.10 | |||
| Variable MOH | $ 5.00 | |||
| Fixed MOH | $ 5.50 | |||
| Total unit product cost | $ 38.10 | |||
Direct labor is a variable cost. The special order would have no
effect on the company's total fixed manufacturing overhead costs.
The customer would like some modifications made to product AB1 that
would increase the variable costs by $4.00 per unit and that would
require a one-time investment of $40,000 in a special jig that
would have no salvage value. This special order would have no
effect on the company's other sales. The company has ample spare
capacity for producing the special order.
Directions: Determine the effect on the
company's total net operating income of accepting the special
order. Show your work!
In: Accounting
Today BandN book stores is currently running a deal on e-books. Customers will receive a 15% discount off their entire order. Customers who buy 20 or more e-books will receive 20% off instead. Each book costs a flat $8.99. Write a C++ program that will calculate the final cost of your order, using functions. Global variables are not allowed unless they are constant. Information should be passed with parameters. Your main function should not do any of the tasks in the list below. The program will print a set of instructions for the user and give a brief explanation of the purpose. It will ask the user for the number of books you wish to download. It will display the number of books to be downloaded, the subtotal for the books, the discount earned and the total cost for the books. You should write a user-defined function to perform each of the following tasks: • print the instructions • prompt and read the number of books to be downloaded • calculate the sub total for those books • calculate the discount for your order • calculate the total cost for the downloaded books • print the results in a neat and well-labeled form
In: Computer Science
In: Accounting
The Apex corporation produces corrugated paper. It has collected monthly data from January 2001 through March 2003 on the following two variables:
y= total manufacturing cost per month (In thousands of dollars) (COST)
x= total machine hours used per month (Machine)
The data are shown below.
| y | x |
1102 218
1008 199
1227 249
1395 277
1710 363
1881 399
1924 411
1246 248
1255 259
1314 266
1557 334
1887 401
1204 238
1211 246
1287 259
1451 286
1828 389
1903 404
1997 430
1363 271
1421 286
1543 317
1774 376
1929 415
1317 260
1302 255
1388 281
Answer the following question
Fill in the blanks for the following statement: “I am 95% confident that the average manufacturing cost at the Apex corporation for all months with 350 total machine hours is between ____ and ____.”
please show me steps
In: Math
Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services, the company has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $23.25 per hundred square feet. However, there is some question about whether the company is actually making any money on jobs for some customers—particularly those located on remote ranches that require considerable travel time. The owner’s daughter, home for the summer from college, has suggested investigating this question using activity-based costing. After some discussion, she designed a simple system consisting of four activity cost pools. The activity cost pools and their activity measures appear below:
| Activity Cost Pool | Activity Measure | Activity for the Year | |
| Cleaning carpets | Square feet cleaned (00s) | 12,000 | hundred square feet |
| Travel to jobs | Miles driven | 328,500 | miles |
| Job support | Number of jobs | 2,000 | jobs |
| Other (organization-sustaining costs and idle capacity costs) | None | Not applicable | |
The total cost of operating the company for the year is $349,000 which includes the following costs:
| Wages | $ | 138,000 |
| Cleaning supplies | 27,000 | |
| Cleaning equipment depreciation | 7,000 | |
| Vehicle expenses | 38,000 | |
| Office expenses | 61,000 | |
| President’s compensation | 78,000 | |
| Total cost | $ | 349,000 |
Resource consumption is distributed across the activities as follows:
| Distribution of Resource Consumption Across Activities | ||||||||||
| Cleaning Carpets | Travel to Jobs | Job Support | Other | Total | ||||||
| Wages | 80 | % | 15 | % | 0 | % | 5 | % | 100 | % |
| Cleaning supplies | 100 | % | 0 | % | 0 | % | 0 | % | 100 | % |
| Cleaning equipment depreciation | 70 | % | 0 | % | 0 | % | 30 | % | 100 | % |
| Vehicle expenses | 0 | % | 82 | % | 0 | % | 18 | % | 100 | % |
| Office expenses | 0 | % | 0 | % | 59 | % | 41 | % | 100 | % |
| President’s compensation | 0 | % | 0 | % | 27 | % | 73 | % | 100 | % |
Job support consists of receiving calls from potential customers at the home office, scheduling jobs, billing, resolving issues, and so on.
Required:
1. Prepare the first-stage allocation of costs to the activity cost pools.
|
2. Compute the activity rates for the activity cost pools
|
3. The company recently completed a 800 square foot carpet-cleaning job at the Flying N Ranch—a 59-mile round-trip journey from the company’s offices in Bozeman. Compute the cost of this job using the activity-based costing system.
4. The revenue from the Flying N Ranch was $186.00 (800 square feet @ $23.25 per hundred square feet). Calculate the customer margin earned on this job.
In: Accounting
One of the large photocopiers used by a printing company has a
number of special functions unique to that particular model. This
photocopier generally performs well but, because of the complexity
of its design and the frequency of usage, it occasionally breaks
down. The department has kept records of the number of breakdowns
per month over the last fifty months. The data is summarized in the
table below:
|
Number of Breakdowns |
Probability |
|
0 |
0.12 |
|
1 |
0.32 |
|
2 |
0.24 |
|
3 |
0.20 |
|
4 |
0.08 |
|
5 |
0.04 |
The cost of a repair depends mainly on the time taken, the level of
expertise required and the cost of any spare parts. There are four
levels of repair. The cost per repair for each level and
probabilities for different levels of repair are shown in table
below:
|
Repair Category |
Repair Cost |
Probability |
|
1 |
$35 |
0.50 |
|
2 |
$75 |
0.30 |
|
3 |
$150 |
0.16 |
|
4 |
$350 |
0.04 |
Based on the probabilities given in the two tables and using the
random number streams given below, simulate for each of 12
consecutive months the number of breakdowns and the repair cost of
each breakdown. Note that for each month you must compute both the
number of breakdowns, the repair cost for each breakdown (if any)
and the total monthly repair cost as well as the total annual
repair cost to answer the following questions.
Use the following random numbers in order (from left to right) for
the simulation of number of breakdowns per month:
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
|
0.13 |
0.21 |
0.08 |
0.09 |
0.89 |
0.26 |
0.65 |
0.28 |
0.97 |
0.24 |
0.10 |
0.90 |
Use the following random numbers in order (from left to right,
first row first - as you need them) for the simulation of repair
cost for each breakdown.
|
0.19 |
0.39 |
0.07 |
0.42 |
0.65 |
0.61 |
0.85 |
0.40 |
0.75 |
0.73 |
0.16 |
0.64 |
|
0.38 |
0.05 |
0.91 |
0.97 |
0.24 |
0.01 |
0.27 |
0.69 |
0.18 |
0.06 |
0.53 |
0.97 |
On which month, the largest number of repairs occurred?
| A. |
September |
|
| B. |
July |
|
| C. |
May |
|
| D. |
December |
|
| E. |
October |
What was the total monthly repair cost in May?
| A. |
$75 |
|
| B. |
$300 |
|
| C. |
$140 |
|
| D. |
$220 |
|
| E. |
$35 |
What is the annual total cost of repairs in this 12-month
simulation?
a) $1845 b) $1485 c) $1570 d) $2250 e) $1480
| A. |
$1845 |
|
| B. |
$1480 |
|
| C. |
$1485 |
|
| D. |
$2250 |
|
| E. |
$1570 |
In: Statistics and Probability
Activity-Based Costing and Conventional Costs
Compared
Hickory Grill Company manufactures two types of cooking grills: the
Gas Cooker and the Charcoal Smoker. The Cooker is a premium product
sold in upscale outdoor shops; the Smoker is sold in major discount
stores. Following is information pertaining to the manufacturing
costs for the current month.
| Gas Cooker | Charcoal Smoker | |
|---|---|---|
| Units | 1,000 | 4,000 |
| Number of batches | 50 | 10 |
| Number of batch moves | 80 | 20 |
| Direct materials | $40,000 | $90,000 |
| Direct labor | $20,000 | $25,000 |
Manufacturing overhead follows:
|
Activity |
Cost |
Cost Driver |
|---|---|---|
| Materials acquisition and inspection | $52,000 |
Amount of direct materials cost |
| Materials movement | 17,450 |
Number of batch moves |
| Scheduling | 30,000 |
Number of batches |
| $99,450 |
a. Determine the total and per-unit costs of manufacturing the
Gas Cooker and Charcoal Smoker for the month, assuming all
manufacturing overhead is assigned on the basis of direct labor
dollars.
Round rate to two decimal places, if
applicable.
Manufacturing overhead based on direct labor dollars: $Answer
per direct labor dollar
Use rounded overhead rate calculated above for calculations below.
Round cost answers to the nearest whole number, when needed. Round
cost per unit to two decimal places, if needed.
| Product Costs per Unit | ||
|---|---|---|
|
Gas Cooker |
Charcoal Smoker |
|
| Direct materials | Answer | Answer |
| Direct labor | Answer | Answer |
| Manufacturing overhead: | Answer | Answer |
| Total cost | Answer | Answer |
| Units | Answer | Answer |
| Cost per unit | Answer | Answer |
b. Determine the total and per-unit costs of manufacturing the
Gas Cooker and Charcoal Smoker for the month, assuming
manufacturing overhead is assigned using activity-based
costing.
Round answers to two decimal place, if needed.
Activity-based overhead rates:
Materials acquisition and handling $Answer
per direct material dollar
Materials movement $Answer
per move
Scheduling $Answer
per batch
Use rounded overhead rate calculated above for calculations below. Round cost answers to the nearest whole number, when needed. Round cost per unit to two decimal places, if needed.
| Product Costs per Unit | ||
|---|---|---|
|
Gas Cooker |
Charcoal Smoker |
|
| Direct materials | Answer | Answer |
| Direct labor | Answer | Answer |
| Manufacturing overhead: | ||
| Materials acquisition | Answer | Answer |
| Materials movement | Answer | Answer |
| Scheduling | Answer | Answer |
| Total cost per batch | Answer | Answer |
| Number of units per batch | Answer | Answer |
| Cost per unit | Answer | Answer |
In: Accounting
Absorption and Variable Costing Income Statements
During the first month of operations ended July 31, YoSan Inc. manufactured 9,900 flat panel televisions, of which 9,200 were sold. Operating data for the month are summarized as follows:
| Sales | $1,334,000 | |
| Manufacturing costs: | ||
| Direct materials | $673,200 | |
| Direct labor | 198,000 | |
| Variable manufacturing cost | 168,300 | |
| Fixed manufacturing cost | 89,100 | 1,128,600 |
| Selling and administrative expenses: | ||
| Variable | $110,400 | |
| Fixed | 50,800 | 161,200 |
Required:
1. Prepare an income statement based on the absorption costing concept.
| YoSan Inc. | ||
| Absorption Costing Income Statement | ||
| For the Month Ended July 31 | ||
| Sales | $ | |
| Cost of goods sold: | ||
| Cost of goods manufactured | $ | |
| Inventory, July 31 | ||
| Total cost of goods sold | ||
| Gross profit | $ | |
| Selling and administrative expenses | ||
| Income from operations | $ | |
2. Prepare an income statement based on the variable costing concept.
| YoSan Inc. | ||
| Variable Costing Income Statement | ||
| For the Month Ended July 31 | ||
| Sales | $ | |
| Variable cost of goods sold: | ||
| Variable cost of goods manufactured | $ | |
| Inventory, July 31 | ||
| Total variable cost of goods sold | ||
| Manufacturing margin | $ | |
| Variable selling and administrative expenses | ||
| Contribution margin | $ | |
| Fixed costs: | ||
| Fixed manufacturing costs | $ | |
| Fixed selling and administrative expenses | ||
| Total fixed costs | ||
| Income from operations | $ | |
Salespersons' Report and Analysis
Walthman Industries Inc. employs seven salespersons to sell and distribute its product throughout the state. Data taken from reports received from the salespersons during the year ended December 31 are as follows:
| Salesperson | Total Sales | Variable Cost of Goods Sold | Variable Selling Expenses | |||||
| Case | $603,000 | $241,200 | $132,660 | |||||
| Dix | 505,000 | 161,600 | 111,100 | |||||
| Johnson | 488,000 | 185,440 | 73,200 | |||||
| LaFave | 523,000 | 271,960 | 73,220 | |||||
| Orcas | 591,000 | 200,940 | 82,740 | |||||
| Sussman | 384,000 | 218,880 | 76,800 | |||||
| Willbond | 544,000 | 184,960 | 92,480 | |||||
Required:
1. Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales, and contribution margin ratio by salesperson. Round percents to the nearest whole number. Enter all amounts as positive numbers.
| Waltham Industries Inc. | ||||
| Salespersons' Analysis | ||||
| For the Year Ended December 31 | ||||
| Salesperson | Contribution Margin | Variable Cost of Goods Sold as a Percent of Sales | Variable Selling Expenses as a Percent of Sales | Contribution Margin Ratio |
| Case | $ | % | % | % |
| Dix | % | % | % | |
| Johnson | % | % | % | |
| LaFave | % | % | % | |
| Orcas | % | % | % | |
| Sussman | % | % | % | |
| Willbond | % | % | % | |
In: Accounting
Morningside Technologies Inc. uses flexible budgets that are based on the following data:
| Sales commissions | 6% of sales |
| Advertising expense | 15% of sales |
| Miscellaneous administrative expense | $1,450 per month plus 3% of sales |
| Office salaries expense | $14,000 per month |
| Customer support expenses | $2,050 plus 4% of sales |
| Research and development expense | 4,500 per month |
Prepare a flexible selling and administrative expenses budget for April for sales volumes of $90,000, $115,000, and $135,000. Enter all amounts as positive numbers.
| Morningside Technologies Inc. | |||
| Flexible Selling and Administrative Expenses Budget | |||
| For the Month Ending April 30 | |||
| Total sales | $90,000 | $115,000 | $135,000 |
| Variable cost: | |||
| Sales commissions | $ | $ | $ |
| Advertising expense | |||
| Miscellaneous administrative expense | |||
| Customer support expenses | |||
| Total variable cost | $ | $ | $ |
| Fixed cost: | |||
| Miscellaneous administrative expense | $ | $ | $ |
| Office salaries expense | |||
| Customer support expenses | |||
| Research and development expense | |||
| Total fixed cost | $ | $ | $ |
| Total selling and administrative expenses | $ | $ | $ |
Personal Budget
At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:
| Cash balance, September 1 (from a summer job) | $6,730 |
| Purchase season football tickets in September | 90 |
| Additional entertainment for each month | 230 |
| Pay fall semester tuition in September | 3,600 |
| Pay rent at the beginning of each month | 320 |
| Pay for food each month | 180 |
| Pay apartment deposit on September 2 (to be returned December 15) | 500 |
| Part-time job earnings each month (net of taxes) | 830 |
a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign.
| KATHERINE MALLOY | ||||
| Cash Budget | ||||
| For the Four Months Ending December 31 | ||||
| September | October | November | December | |
| Estimated cash receipts from: | ||||
| Part-time job | $ | $ | $ | $ |
| Deposit | ||||
| Total cash receipts | $ | $ | $ | $ |
| Estimated cash payments for: | ||||
| Season football tickets | $ | |||
| Additional entertainment | $ | $ | $ | |
| Tuition | ||||
| Rent | ||||
| Food | ||||
| Deposit | ||||
| Total cash payments | $ | $ | $ | $ |
| Overall cash increase (decrease) | $ | $ | $ | $ |
| Cash balance at beginning of month | ||||
| Cash balance at end of month | $ | $ | $ | $ |
b. Are the four monthly budgets that are
presented prepared as static budgets or flexible budgets?
c. Malloy can see that her present
plan sufficient cash. If Malloy did not budget but
went ahead with the original plan, she would be
$ at the end of December, with no time left to
adjust.
Static Budget versus Flexible Budget
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static budget for the upcoming year:
| Niland Company Machining Department Monthly Production Budget |
|
| Wages | $396,000 |
| Utilities | 34,000 |
| Depreciation | 57,000 |
| Total | $487,000 |
The actual amount spent and the actual units produced in the first three months in the Machining Department were as follows:
| Amount Spent | Units Produced | |||
| January | $460,000 | 121,000 | ||
| February | 441,000 | 110,000 | ||
| March | 422,000 | 99,000 | ||
The Machining Department supervisor has been very pleased with this performance because actual expenditures for January–March have been less than the monthly static budget of $487,000. However, the plant manager believes that the budget should not remain fixed for every month but should “flex” or adjust to the volume of work that is produced in the Machining Department. Additional budget information for the Machining Department is as follows:
| Wages per hour | $15.00 |
| Utility cost per direct labor hour | $1.30 |
| Direct labor hours per unit | 0.20 |
| Planned monthly unit production | 132,000 |
a. Prepare a flexible budget for the actual units produced for January, February, and March in the Machining Department. Assume that depreciation is a fixed cost. Enter all amounts as positive numbers. If required, use per unit amounts carried out to two decimal places.
| Niland Company-Machining Department | |||
| Flexible Production Budget | |||
| For the Three Months Ending March 31 | |||
| January | February | March | |
| Units of production | |||
| Wages | $ | $ | $ |
| Utilities | |||
| Depreciation | |||
| Total | $ | $ | $ |
b. Compare the flexible budget with the actual expenditures for the first three months.
| January | February | March | |
| Total flexible budget | $ | $ | $ |
| Actual cost | |||
| Excess of actual cost over budget | $ | $ | $ |
What does this comparison suggest?
| The Machining Department has performed better than originally thought. | |
| The department is spending more than would be expected. |
Flexible Budget for Assembly Department
Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department:
| Direct labor per filing cabinet | 30 minutes |
| Supervisor salaries | $147,000 per month |
| Depreciation | $20,000 per month |
| Direct labor rate | $15 per hour |
Prepare a flexible budget for 14,000, 18,000, and 21,000 filing cabinets for the month of August in the Assembly Department, similar to Exhibit 5. Assuming that inventories are not significant. Enter all amounts as positive numbers.
| CABINAIRE INC-ASSEMBLY DEPARTMENT | |||
| Flexible Production Budget | |||
| For the Month Ending August 31 (assumed data) | |||
| Units of production | 14,000 | 18,000 | 21,000 |
| Variable cost: | |||
| Direct labor | $ | $ | $ |
| Total variable cost | $ | $ | $ |
| Fixed cost: | |||
| Supervisor salaries | $ | $ | $ |
| Depreciation | |||
| Total fixed cost | $ | $ | $ |
| Total department cost | $ | $ | $ |
In: Accounting