Cairo Consulting wants to determine whether reselling process consulting services provided by third parties would reduce the costs of this type of consulting. Switch to the Process Providers worksheet, and then run Solver to solve this problem as follows: Set the objective as minimizing the value in cell E10 (Total Costs). Use the range B4:D4 as the changing variable cells. Adjust the hours provided by each company using the following constraints: E4-5500, the total hours of process consulting signed E10 is less than or equal to 1350000, the maximum third-party fees B4:D4 is less than or equal to 5000, the maximum hours provided by a single third-party provider B4:D4 should be an Integer Run Solver, keep the solution, and then return to the Solver Parameters dialog box. Save the model to the range A14:A21, and then close the Solver Parameters dialog box. a. b. C. d. e. f. 9.
Q: French Taylor is a new staff accountant for Fashion House Beauty Supply. He has asked you to review…
A: Income Statement is the financial statement that records all the income and expenses of the business…
Q: On December 31, 2020, Sarasota Co. performed environmental consulting services for Hayduke Co.…
A: A journal entry is a record of the commercial transaction in the accounting system of a company.…
Q: During the month of June, Marigold Boutique recorded cash sales of $323,400 and credit sales of…
A: Journal entries are the basic method for recording financial transactions in the books of accounts.…
Q: Alester holds a Php32,400 simple interest note at 12.5% rate from Chloe which is payable in one…
A: Step-by-step explanation:- The final value of the note at 12.5% simple interest = 32,400 x 1.125 =…
Q: Tiger Equipment Inc., a manufacturer of construction equipment, prepared the following factory…
A: Variance is the difference between the actual costs and the budgeted costs. When the budgeted cost…
Q: the average daily balance method to compute the finance charge on the credit card account for the…
A: Average Daily Balance method is a method which is generally used by the credit card company for…
Q: Bemidii Company has the following data for one of its production departments: Theoretical velocity:…
A: Conversion cost per units means the cost of labor and overhead per unit of product. It is reported…
Q: At age 22, someone sets up an IRA (individual retirement account) with an APR of 7%. At the end of…
A: the answer is given below
Q: Eastern Airlines reports the following cost data for the year. The company flew 100 private flights…
A: The question is based on the concept of Cost Accounting. Contribution margin is the difference…
Q: Daley Company prepared the following aging of receivables analysis at December 31. Days Past…
A: Under the aging method, first the post adjustment in allowance for doubtful accounts is computed.…
Q: . Zion Associates, a start-up Boston-based engineering company, just hired you as payroll…
A: Answer:- Internal controls meaning:- Internal controls are the systems, guidelines, and practices…
Q: B) If one birchbark canoe can travel up to 16 km/h, then the equation for distance versus time would…
A: There are multiple questions asked without specifying the question number for which one to be solved…
Q: red 90% of the ord 125m on 31 Decen ets were as follows
A: Goodwill - An intangible asset known as goodwill is connected to the acquisition of one business by…
Q: Ralph Collins founded Collins Consignment Sales Company and the company was operated from his home.…
A: Note: Since we only answer up to 3 sub−parts, we’ll answer the first 3. Please resubmit the question…
Q: Distinguish between the general audit objectives and management assertions. Why are the general…
A: The purpose of audit is to form the independent opinion on the audited financial statements of the…
Q: Required: 1. Prepare, in good form, a weighted average cost of production report for the Curing…
A: Production report can be called as the summary of all the costs that are incurred in the production…
Q: Determine the present value, P, you must invest to have the future value, A, at simple interest rate…
A: calculation of present value P are as follows
Q: 17. Assume a token swap at DEX SashimiSwap costs 100,000 gas and the baseFee is currently (in March…
A: Introduction A community marketplace known as a decentralized exchange (or DEX) is where…
Q: If Sudar Products Bhd follows the residual distributions model:(ii) How much retained earnings and…
A: Residual distribution model is the method in which dividend is paid after the capital repayment has…
Q: Make a partial depreciation schedule for the third year using the units of production depreciation…
A: Depreciation is the decrease in the value of assets as a result of use in business, passage of time,…
Q: Coast to Coast Surfboards Inc. manufactures and sells two styles of surfboards, Atlantic Wave and…
A: Contribution Margin :— It is the difference between sales revenue and total variable cost.…
Q: 2. Wonderful! Not only did our salespeople do a good job in meeting the sales budget this year, but…
A: The study of variances between actual behavior and predicted or planned behavior in budgeting or…
Q: Find the compound amount if Php82,000 is invested at 11% compounded monthly for 3 years.…
A: Formula to find out the Compound Amount = P (1 + i )t where, P = Principal Amount i =…
Q: How many period 000 to accumulate inded annually?
A: Answer : Amount invested = 23,000 Amount in future = 25000 Interest rate = 12% Calculate time period…
Q: E8.15 (LO 4) A new accountant at Wyne Inc. is trying to identify which of the amounts shown below…
A: Cash includes coins and currency and demand deposits that the firms or household can demand anytime.…
Q: What accounts should Free credit to record the issuance of the bonds and warrants? a. Bonds Payable…
A: Bonds payable is a liability account that holds the sum that the issuer owes bondholders.Given that…
Q: Problem no. 3 Keepin makes fencing in a two-stage production system. In the Cutting Department, wood…
A:
Q: On December 1, Daw Company accepts a $48,000, 45-day, 10% note from a customer. (1) Prepare the…
A: Working :- 1) Calculation of interest receivable on December 31 i.e. for 30 days (from 1 December…
Q: Conchita Martinez will have a monthly interest and principal payment of $1,820.68. Her monthly real…
A: The housing expense ratio, also known as the front-end ratio, is a percentage determined by dividing…
Q: What does the additional paid-in capital account represent? a) The difference between the par and…
A: When a company issues fresh shares for a price more than the par value of a share, excess amount is…
Q: Question 1: Prepare the Income Statement for the year ended 31 December 2021 using the absorption…
A: Variable costing is the method of costing, where the cost of units is measured in terms of variable…
Q: $ 1,000 Balance Sheet: Assets Cash $ 150 Short-term investments $ 130 Accounts…
A: Operating assets refers to the those types of assets which are used in the day to day transactions…
Q: 2. Prepare the journal entries for the following transactions of Lily Express Service Company for…
A: The question demands from us the journals and the T-accounts along with the balance for the month of…
Q: How many units would have to be sold each month to attain a target profit of 35,400
A: The contribution margin per unit is calculated as difference between sales and variable costs per…
Q: 1. Prepare the journal entries for the following transactions of Sun and Moon Resort for the month…
A: 1. Journal Entries - Journal Entries are the records of the transactions entered into by the…
Q: The following selected transactions were completed during August between Summit Company and…
A: Solution: Journal entry: In the book of Summit Company: Date Account…
Q: Melchar Company uses 78,125 pounds of oats each year. The cost of placing an order is $18, and the…
A: EOQ represents the ordering level which has the lowest inventory cost.
Q: CTL (Concrete Testing Lab) borrowed $40,000 for new equipment at 11% per year, compounded quarterly.…
A: The question is based on the concept of Annuity in Financial Accounting. In the above question the…
Q: Tableau Dashboard Activity 07-01: Depreciation (Static) Penguin Network Warehouses, LLC ("PNW, LLC")…
A: Answer:- Depreciation is the amount deducted from the cost of the asset on account of wear and tear…
Q: ,000 $ 39,000 $ 70,000 $ 56,000 $ 38,000 $ 280,000 Expenses Avoidable 14,800 42,400…
A: Net Income - Net income is the remaining amount after costs of products sold and other expenses have…
Q: Depreciation Expense Change in salaries payable Gain from sale of equipment Change in common stock…
A: calculation of cash flow from operation are as follows
Q: What two accounts are affected when $558,000 of direct materials is used in production?
A: Journal entry to record the use of direct materials in production : Work-in-process inventory is…
Q: Garden Yeti manufactures garden sculptures. Each sculpture requires 8 pounds of direct materials at…
A: The direct materials budget, that breaks down the resources that must be acquired so over course of…
Q: James Inc. makes industrial solvents sold in 5-gallon drums. Planned production in units for the…
A: Cost accounting is a type of accounting that records and measures the cost of good manufactured,…
Q: A manager is trying to decide whether to buy one machine or two. If only one is purchased and demand…
A: A manager is trying to decide whether to buy one machine or two. If only one machine is purchased…
Q: estion 5 How many days are there between November 24, 2015 to March 28, 2016? 124 days 115 days 125…
A: Calendar Days Full calendar Days refers to any day of the chronological year, including holidays,…
Q: detail for its activities and its product at the start of the period: Budgeted overhead = £400,000…
A: The overhead is applied to the production on the basis of predetermined overhead rate. The overhead…
Q: Absorption and Variable Costing Income Statements During the first month of operations ended July…
A: As per the absorption costing method, the product cost includes fixed and variable manufacturing…
Q: reate the journal entry for the transactions below
A: Date Particulars Amount (Debit) 1-Mar Cash 60000 Bank Note Payable 60000…
Q: The following information is available to reconcile Branch Company's book balance of cash with its…
A: The bank reconciliation statement is prepared to equate the balances of cash book and passbook with…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
- Q3. ADLG Company has two support departments, SS1 and SS2, and two operating departments, OD1 and OD2. The company has decided to use the direct method and allocate variable SS1 dept. costs based on the number of transactions and fixed SS1 dept. costs based on the number of employees. SS2 dept. variable costs will be allocated based on the number of service requests and fixed costs will be allocated based on the number of computers. The following values have been extracted for the allocation | Total Department variable costs Total department fixed costs Number of transactions Number of employees Number of service requests Number of computers Support Departments SS1 16,000 19,500 50 18 37 20 SS2 19,000 34,000 You are required to allocate variable and fixed costs. 55 24 22 25 Operating Departments OD1 105,000 120,000 250 47 26 31 OD2 68,000 55,000 140 38 32 37Q2. PPLC Company has two support departments, SD1 and SD2, and two operating departments, ODI and OD2. The company decided to use the direct method and allocate variable SD1 dept. costs based on the number of transactions and fixed SD1 dept. costs based on the number of employees. SD2 dept. variable costs will be allocated based on the number of service requests, and fixed costs will be allocated based on the number of computers. The following information is provided: (4 Marks) (Chapter 8, Week 10) Support Departments Operating Departments SD1 SD2 ODI OD2 Total Department variable costs 18,000 19,000 51,000 35,000 Total department fixed costs 20,000 24,000 56,000 30,000 Number of transactions 30 40 200 100 Number of employees 14 18 35 30 Number of service requests 28 18 35 25 Number of computers 15 20 24 28 You are required to allocate variable and fixed costs using direct method.The Connors Company has assembled the following data pertaining to certain costs that cannot beeasily identified as either fixed or variable. Connors Company has heard about a method of measuringcost functions called the high-low method and has decided to use it in this situation.A company has heard about a method of measuring cost functions called the regression analysis and hasdecided to use it in this situation.Cost Hours$23,000 5,000$26,000 6,450$34,600 7,650$42,000 10,000$38,000 9,350What is the estimated total cost at an operating level of 9,000 hours?A) $34,200B) $38,200C) $41,400D) $37,800 Work question #7 using regression analysis
- Almed Products has determined that the number of machine hours worked (MH) drives the amount of manufacturing overhead incurred (MOH). On the basis of this relationship, a staff analyst has constructed the following regression equation: MOH = 240,000 + 8MH Which of the choices correctly depicts the nature of Almed’s variables? Dependent Independent A. MOH MOH B. MOH MH C. MH MOH D. MH MH E. 8 240,000 Multiple Choice Choice A Choice B Choice C Choice D Choice EHoward Cooper, the president of Thornton Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 42,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Thornton charges customers $79 per hour, the firm can achieve 48,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the…Question 2 A seminar was recently attended by the Managing Director of XYZ Manufacturing Company Limited located at Sheffield. The focus of the seminar was "optimising scarce resources utility in a manufacturing setting with particular reference to linear programming". On his return to his base, he called for a meeting with the Management to share his experience from the seminar and the impact this will have on the decision by the Board to produce two major products in the years ahead. A group of external research experts had previously been commissioned and the following represents information from the research carried out by them The expected products are "Best" and "Smart" with expected costs statistics as follows: Best £ £ Smart (3kg@£50/kg) Material costs (5kg@£50/kg) 250 150 Labour costs Machinery time 30 (4 hours @£15/Hr) 60 (4 hours @£10/hr) 40 (2hours @£15/Hr) (5hours@£10/Hr) Other Processing Time 50 The applicable pricing policy is based on total cost of production plus 20%…
- An operations manager is deciding on the level of automation for a new process. The fixed cost for automation includes the equipment purchase price, installation, and initial spare parts. The variable costs per unit for each level of automation are primarily labor related. Each unit can be sold for $81. As in many cases, you have the default alternative of doing nothing ($0 fixed cost, $0 variable costs). Hint: For these questions, also consider the “Do Nothing” option as a viable option when making your decision. Alternative Fixed Costs Variable Costs per Unit A $100,000 $54 B $272,000 $31 C $560,000 $20 Recommended: graph each alternative with units on the x-axis and $ on the y-axis. Also, include revenue on the chart. Identify the break-even points and points of indifference.That is, it is unacceptable to manually compute the solutions and simply insert the answers into the cells of an excel spreadsheet.) Raiders Ltd CVP Problem Prepare an Excel worksheet that illustrates cost-volume-profit (CVP) analysis, also referred to as breakeven analysis. Assume that a particular product sold at Raiders Ltd a US based toy company has a sales price per unit of $4.00; variable cost per unit of $2.20; and total fixed cost of $100,000. Task 1) Calculate the contribution margin per unit, the break-even point in units of sales, and the break-even point in dollars of sales. In the inputarea, show sales price per unit, variable cost per unit, and total fixed cost. In the output area, show contribution margin per unit, breakeven point in units, and breakeven point in dollars computed using appropriate formulas. Task 2) Assume that the planning team at Raiders Ltd estimates that for the next planning period selling price for this product will increase 50%; variable expenses…Howard Cooper, the president of Stuart Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 30,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Stuart charges customers $80 per hour, the firm can achieve 36,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm…
- Theta, Inc., a manufacturing company, has two major activities that drive the selling costs of the firm, namely commission paid to sales agents on the number of sales initiated and number of dispatches made. In the case of two explanatory variables, the linear equation is expanded to include the additional variable:Y = F + V1X1 + V2X2, whereX1 = Number of sales initiated by representativesX2 = Number of dispatches madeF = Fixed cost componentY = Total selling costsWhich of the following is a dependent component in the equation above? a.Number of sales initiated by representatives b.Fixed cost component c.Number of dispatches made d.Total selling costsBurger Office Equipment produces two types of desks, standard and deluxe. Deluxe desks have oak tops and more expensive hardware and require additional time for finishing and polishing. After reviewing the hardware and labor required along with the profit for each model, Burger Office Equipment found the following linear optimization model for profit, where S is the number of standard desks produced and D is the number of deluxe desks produced. Implement the linear optimization model on a spreadsheet and use Solver to find an optimal solution. Interpret the optimal solution, identify the binding constraints, and verify the values of the slack variables. Maximize Profit=240 S+350 D 65 S+45 D≤6000 20 D≤ 800 (Availability of pine) 9 S+18 D≤500 S≥0 and D≥0 (Availability of oak) (Availability of labor) Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce standard desks and deluxe desks. This solution gives…An operations manager is deciding on the level of automation for a new process. The fixed cost for automation includes the equipment purchase price, installation, and initial spare parts. The variable costs per unit for each level of automation are primarily labor related. Each unit can be sold for $90. As in many cases, you have the default alternative of doing nothing ($0 fixed cost, $0 variable costs). Hint: For these questions, also consider the "Do Nothing" option as a viable option when making your decision. Alternative Fixed Costs A B C $100,000 $268,000 $560,000 Variable Costs per Unit $54 $30 $20 Recommended: graph each alternative with units on the x-axis and $ on the y-axis. Also, include revenue on the chart. Identify the break-even points and points of indifference. For help on this, see the video posted in Moodle. When comparing Alternative B to Alternative C, C is the most attractive option above units. DO NOT INCLUDE A COMMA. Round your answer to the nearest whole…