AirQual Test Corporation provides on-site air quality testing services. The company has provided the following cost formulas and actual results for the month of February: Fixed Component per Month Variable Component per Job Actual Total for February Revenue $ 276 $ 38,650 Technician wages $ 8,500 $ 8,350 Mobile lab operating expenses $ 4,900 $ 33 $ 9,690 Office expenses $ 2,500 $ 2 $ 2,650 Advertising expenses $ 1,580 $ 1,650 Insurance $ 2,890 $ 2,890 Miscellaneous expenses $ 950 $ 2 $ 555 The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $4,900 plus $33 per job, and the actual mobile lab operating expenses for February were $9,690. The company expected to work 150 jobs in February, but actually worked 160 jobs. Required: Prepare a flexible budget performance report showing AirQual Test Corporation’s revenue and spending variances and activity variances for February. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
Prepare a flexible budget performance report showing AirQual Test Corporation’s revenue and spending variances and activity variances for February. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Cane Company manufactures two products called Alpha and Beta that sell for $210 and $172, respectively. Each product uses only one type of raw material that costs $8 per pound. The company has the capacity to annually produce 128,000 units of each product. Its average cost per unit for each product at this level of activity are given below:
| Alpha | Beta | |||||||
| Direct materials | $ | 40 | $ | 24 | ||||
| Direct labor | 38 | 34 | ||||||
| Variable manufacturing overhead | 25 | 23 | ||||||
| Traceable fixed manufacturing overhead | 33 | 36 | ||||||
| Variable selling expenses | 30 | 26 | ||||||
| Common fixed expenses | 33 | 28 | ||||||
| Total cost per unit | $ | 199 | $ | 171 | ||||
The company considers its traceable fixed manufacturing overhead to be avoidable, whereas its common fixed expenses are unavoidable and have been allocated to products based on sales dollars.
12. What contribution margin per pound of raw material is earned by each of the two products?
13. Assume that Cane’s customers would buy a maximum of 98,000 units of Alpha and 78,000 units of Beta. Also assume that the company’s raw material available for production is limited to 248,000 pounds. How many units of each product should Cane produce to maximize its profits?
14. Assume that Cane’s customers would buy a maximum of 98,000 units of Alpha and 78,000 units of Beta. Also assume that the company’s raw material available for production is limited to 248,000 pounds. What is the maximum contribution margin Cane Company can earn given the limited quantity of raw materials?
15. Assume that Cane’s customers would buy a maximum of 98,000 units of Alpha and 78,000 units of Beta. Also assume that the company’s raw material available for production is limited to 248,000 pounds. If Cane uses its 248,000 pounds of raw materials, up to how much should it be willing to pay per pound for additional raw materials? (Round your answer to 2 decimal places.)
In: Accounting
Assume that Cane’s customers would buy a maximum of 94,000 units of Alpha and 74,000 units of Beta. Also assume that the company’s raw material available for production is limited to 228,000 pounds. If Cane uses its 228,000 pounds of raw materials, up to how much should it be willing to pay per pound for additional raw materials?
Cane Company manufactures two products called Alpha and Beta that sell for $190 and $155, respectively. Each product uses only one type of raw material that costs $8 per pound. The company has the capacity to annually produce 122,000 units of each product. Its average cost per unit for each product at this level of activity are given below:
| Alpha | Beta | |||||||
| Direct materials | $ | 40 | $ | 24 | ||||
| Direct labor | 34 | 28 | ||||||
| Variable manufacturing overhead | 21 | 19 | ||||||
| Traceable fixed manufacturing overhead | 29 | 32 | ||||||
| Variable selling expenses | 26 | 22 | ||||||
| Common fixed expenses | 29 | 24 | ||||||
| Total cost per unit | $ | 179 | $ | 149 | ||||
The company considers its traceable fixed manufacturing overhead to be avoidable, whereas its common fixed expenses are unavoidable and have been allocated to products based on sales dollars.
What contribution margin per pound of raw material is earned by each of the two products?
Assume that Cane’s customers would buy a maximum of 94,000 units of Alpha and 74,000 units of Beta. Also assume that the company’s raw material available for production is limited to 228,000 pounds. How many units of each product should Cane produce to maximize its profits?
Assume that Cane’s customers would buy a maximum of 94,000 units of Alpha and 74,000 units of Beta. Also assume that the company’s raw material available for production is limited to 228,000 pounds. What is the maximum contribution margin Cane Company can earn given the limited quantity of raw materials?
In: Accounting
Develop a report that includes the following sections: (Use the required sections as headers in your report.) Section I: Overview Provide a general overview of QuickBooks. Make sure the overview provides the reader with a general understanding of the application, including costs, functionality and minimum system requirements. Section II: Transactional Processing and Data Management Describe how QuickBooks handles processing the accounting transactions and recording business activities for the revenue, expenditure and financing cycles. You should provide at least one detailed example of how one would record a specific accounting transaction/ business activity for each of the three transaction cycles below. Address the following questions in this section of the report. Revenue Cycle (Answer the following questions) How can you create and maintain customers? How can you create customer invoices? How can you apply customer payments? What reports can you run to provide you with information regarding your customers and their orders? Describe them. What reports can you run in order to provide you with information regarding key revenue cycle information - sales, accounts receivable, cash? Expenditure Cycle (Answer the following questions) How can you create and maintain vendors? How can you create and maintain inventory? How can you generate payments to vendors? What reports can you run to provide you with information regarding your vendors and your accounts payable? Describe them. What reports can you run in order to provide you with information regarding key expenditure cycle information – purchases, inventory, and cash? Financing Cycle (Answer the following questions) How can you create and maintain the chart of accounts? How can you post journal entries? What are the key financial statements that are available? Describe them. What are some key reports one can generate to measure the firm’s financial performance? Section III: Internal Controls How can QuickBooks enhance internal controls? How can you secure the system and files? What potential security weaknesses exist for QuickBooks? Section IV: Charts and Graphs How are visualizations formatted and used? What charts are available and how are charts created? What is a data diagram in QuickBooks?
In: Accounting
Assume that on December 1, 2020, Lee Dunbar organizes a sole proprietorship company that will be known as App Solutions. App Solutions will initially perform 2 activities: Application Consulting and Programming.
The following transactions take place during the month of December:
Dec. 1 To start the business, Lee deposits $50,000 into the App Solution’s bank account.
Dec. 1 Web Solutions purchased a small office building for $220,000, paying $20,000 cash, and assuming a mortgage with a bank for the rest.
Dec. 1 Purchased supplies on account for $1,350.
Dec. 2 Received $7,500 cash for Application Consulting to be provided to customers in December.
Dec. 2 Paid a premium of $2,400 on a comprehensive insurance policy covering liability, theft, and fire. The policy covers a 1 year period, to November 30, 2020.
Dec. 2 Paid rent for the month of December, $1,800.
Dec. 3 Received an offer from a local retailer to rent the ground floor of the small office building purchased on Dec. 1st. App Solutions received $3,600 for three months’ rent beginning December 1st.
Dec. 4 Purchased computer equipment on account from Executive Supply Co. for $3,600.
Dec. 6 Paid $180 for a newspaper advertisement, to be run immediately.
Dec. 11 Paid creditors $400 for the Dec. 1st supplies purchase.
Dec. 15 Paid a receptionist and part-time assistant $1,950 each for wages for first half of December.
Dec. 16 Received $3,100 from Programming fees earned for a completed Web site.
Dec. 16 Completed work for prepaid Application Consulting from Dec. 2.
Dec. 20 Paid $1,800 to Executive Supply Co. on the debt owed from the December 4th transaction.
Dec. 21 Received $650 cash from customers for Application Consulting performed in the last few days.
Dec. 23 Purchased $1,450 of supplies by paying $550 in cash and charging the remainder on account.
Dec. 27 Paid the receptionist and the part-time assistant $1,950 each for wages for second half of December.
Dec. 31 Paid telephone for the month of December, $250.
Dec. 31 Paid $225 electricity bill for December.
Dec. 31 Received $2,870 cash from Application Consulting completed the last few days of December.
Dec. 31 Recognized Programming fees earned by not paid of $1,120 from the second half of December.
Dec. 31 Lee withdrew $3,000 from the company bank account for his own personal use.
Instructions (50 Marks in total):
Please Note: Do not apply any adjustments for the month of December 2020.
Use an Excel Spreadsheet file with five worksheets:
First worksheet: Documentation
Second worksheet: Chart of Accounts.
Third worksheet: General Journal.
Fourth worksheet: T-Accounts.
Fifth worksheet: Unadjusted Trial Balance.
In: Accounting
McEwan Industries sells on terms of 3/10, net 30. Total sales for the year are $1,150,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 90 days after their purchases. Assume 365 days in year for your calculations.
| Nominal cost: | % |
| Effective cost: | % |
In: Finance
Your firm purchases a machine for $72,662. You purchase the
machine using current available cash-balances from a previous
period.
You have sales from your retail customers of $289,729. These
customers pay with cash.
Your sales from commercial consumers are $31,864. These customers
pay with credit.
The cost of your overhead is $17,463 which you pay for with
credit.
You have variable costs of $11,658 which you pay for with
cash.
Your firm's tax rate is 25%
Finally, you collect on past accounts receivable for $4,536 and pay
off past accounts payable for $6,886.
The depreciation schedule is given by:
Depreciation Percentage
Year 1 0.33
Year 2 0.45
Year 3 0.15
Year 4 0.07
What is the free cash-flow in year 1?
Group of answer choices
$135,935.62
$157,845.28
$208,597.62
$186,091.28
In: Finance
Your firm purchases a machine for $95,900. You purchase the machine using current available cash-balances from a previous period. You have sales from your retail customers of $267,000. These customers pay with cash. Your sales from commercial consumers are $33,600. These customers pay with credit. The cost of your overhead is $18,200 which you pay for with credit. You have variable costs of $23,820 which you pay for with cash. Your firm's tax rate is 14% Finally, you collect on past accounts receivable for $1,130 and pay off past accounts payable for $1,150. The depreciation schedule is given by: Depreciation Percentage Year 1 0.33 Year 2 0.45 Year 3 0.15 Year 4 0.07 What is the free cash-flow in year 1? Group of answer choices $145,920.13 $211,389.38 $121,109.38 $115,489.38
In: Finance
The Edward H. & Wael F. (E & W) firm currently sells its product with a 2% discount to customers who pay by cash or credit card when they purchase one of the firm’s products; otherwise, the full price is due within 30 days. Sixty percent of customers take advantage of the discount. The firm plans to drop the discount so the new terms will simply be net 30. In doing so, it expects to sell 150 fewer units per month and all customers to pay at day 30. The E&W firm currently sells 1500 units per month at a cost per unit of $45 and a selling price per unit of $80. If the firm’s required return is 3%, what is the net present value (NPV) of making this change? (Show all the steps and your calculations; see the example 19.4).
In: Finance
A small branch bank has two tellers, one for deposits and one for withdrawals. Customers arrive at each teller’s window with an average rate of 18 customers per hour. (The total customer arrival rate is 36 per hour.) The interarrival times are exponential. The service time of each teller is exponential with a mean of 3 minutes. The bank manager is considering changing the setup to allow each teller to handle both withdrawals and deposits to avoid the situations that arise from time to time when the queue is sizable in front of one teller while the other is idle. However, since the tellers would have to handle both deposits and withdrawals, their efficiency would decrease to a mean service time of 3.2 minutes. Compare the present system with the proposed system with respect to the total average number of customers in the banks and the average time a customer would have to spend in the bank.
In: Statistics and Probability