Reference no: EM13877189
Master Budget, Flexible Budget, and Profit-Variance Analysis Going into the period just ended, Ortiz & Co., manufacturer of a moderately priced espresso maker for retail sale, had planned to produce and sell 3,900 units at $100 per unit. Budgeted variable manufacturing costs per unit are $50. Ortiz pays its salespeople a 10 percent sales commission, which is the only variable nonmanufacturing cost for the company. Fixed costs are budgeted as follows: manufacturing, $50,000; marketing, $36,000.
Actual financial results for the period were disappointing. While sales volume was up (4,000 units sold), actual operating profit was only $20,000 for the period. Fixed manufacturing costs were as budgeted, but fixed marketing expenses exceeded budget by $4,000. Actual sales revenue for the period was $390,000, and actual variable costs were $70 per unit (the actual sales commission was 10 percent of sales revenue generated).
Required
1. Develop an Excel spreadsheet that is able to produce a profit-variance report similar to the one presented in text Exhibit.
2. Use the spreadsheet you developed in (1) and the data presented above to complete the profit-variance report for the period. Below the table you create, show separately the following variances:
a. Total master (static) budget variance (i.e., the total operating-income variance for the period).
b. Total flexible-budget variance.
c. Flexible-budget variance for total variable costs, plus the flexible-budget variance for:
(1) variable manufacturing costs.
(2) variable nonmanufacturing costs.
d. Flexible-budget variance for total fixed costs, plus the flexible-budget variance for:
(1) fixed manufacturing costs.
(2) fixed nonmanufacturing costs.
3. Provide a concise interpretation for each of the variances calculated above in (2).
4. Using the variances you calculated above in (2), prepare in as much detail as the data allow, a separate summary report similar to text.
What impact does the ruling have on each of them
: Who are the stakeholders in this case? What impact does the ruling have on each of them? Sup- pose Castro had been ?red after reporting health or safety violations in the workplace.
|
What is the model multiplier
: Assume a government expenditure of $2216.8 and a net export of -$615.4- determine the equilibrium national income, consumption and investment.
|
Experience neither plastic deformation
: A cylindrical rod 380 mm (15.0 in.) long, having a diameter of 10.0 mm (0.40 in.), is to be subjected to a tensile load. If the rod is to experience neither plastic deformation nor an elongation of more than 0.9 mm (0.035 in.) when the applied loa..
|
Calculate occs preliminary net income for september
: Using your answer to requirement 1 or 2, calculate OCC's preliminary net income for September. Is OCC profitable, based on its preliminary net income? Identify at least two adjustments that OCC will be required to make before it can prepare a final i..
|
Develop spreadsheet that is able to produce profit-variance
: Develop an Excel spreadsheet that is able to produce a profit-variance report similar to the one presented in text Exhibit.
|
Write a program that asks for the starting time
: Write a program that asks for the starting time and the number of minutes of the call, and display the charges. The program should ask for the time to be entered as a floating-point number in the form HH.MM. For example, 07:00 hours will be entered a..
|
From the worker''s gross pay
: An employee is paid at a rate of $16.78 per hour for the first 40 hours worked in a week. Any hours over the regular 40 hours are paid at the overtime rate of one-and-one-half times that. From the worker's gross pay
|
Organizational impact of a newly implemented erp system
: Describe the organizational impact of a newly implemented ERP system. Describe new organizational capabilities of typical ERP systems. Describe the ability of the organization to adapt to change on ERP implementation
|
Write the reduced form of the model
: Assume G0 = 545 and write the reduced form of the model. Linearly approximate Y by expanding the reduced form around 3390.
|