Question
Hi, I need help with Question one, please Question 1: 1. Based on the 2014 income statement (Exhibits 1 & 2), do you agree with
Hi, I need help with Question one, please
Question 1: 1. Based on the 2014 income statement (Exhibits 1 & 2), do you agree with Majdy's decision to keep product C? Why? After reading the case and relevant notes, students should go directly to Exhibit 2 where you can find sales and cost information related to three products. Where CM can be determined for A, B, C. Then you need to identify profit margin per unit then check if dropping will save fixed costs and check the CM. Then check, what consequences on the long-term can affect the company if you decide to drop or keep and recommend what to do.
Question 2: Students should analyze the difference between the product actual and standard information by focusing on two major aspects price and variable cost. Then students need to identify if reducing product price what will happen to total CM. Students can also check company's marketing efforts and the reflection on total contribution margin. Question 3: Students should list the reasons why the company's profitability increased during the first half of 2015. Give special focus on product B and the fixed costs of the company. Also compare the standard and actual variable and fixed costs (half of 2014 and the first half of 2015) for all products and contribution margin for products money and quantities. In order to do so, you need to prepare: 1. CM per unit (per 100 kilogram) for the 3 products in 2014 (half year). 2. CM per unit (per 100 kilogram) for the 3 products in 2015. 3. Analyzing the variance (the difference) between 2014 (half year) and 2015. Question 4: After the previous analysis on the costing system of the company, Students are required to identify case related-issues on: 1. The capacity of the company and the effect on cost. 2. What information you can provide the company on the variance in the variable costs in exhibit 4. 3. Evaluate the allocation base of the company with suggestions. 4. Analyze the selling expenses with your comments and feedback. 5. After identifying disadvantages of the current costing system, is there any positive features about the current costing system. No calculations are required for this question.
Exhibit 1 income statement for year ending December 31, 2014 (in thousands) $105,905 (1.567 $104,338 (65,251) $39,087 Gross sales Cash Discount Net Sales Cost of Manufacturing Gross profit Less: Selling Expense General Administration Depreciation Operating Profit Plus: Other Income Net Profit before Interest Less: Interest $18,383 6,534 13.591 (38,508) $579 205 $784 (1.472) Net Income (6688) Exhibit 2 Analysis of income statement by products and departments-Year ended December 31, 2014 (thousands $ except per 100 kilograms.) Product A Per 100 kgs. Classification Direct Indirect Total Allocation Basis .49 X X Cubic space Area Value of equipment Direct labor ($) X Direct labor ($) Machine horsepower Area Area Rent Property Taxes Property Insurance Compensation Insurance Direct Labor Indirect Labor Power Light & Heat Building Service Materials Supplies Repairs Total Selling Expense General Administrative Depreciation Interest Total Cost Less: Other Income $ 1.872 621 524 836 12,937 4,413 220 158 109 7641 525 184 $30,040 9,100 3,451 5,659 524 $48,774 101 $48,673 51,672 $2,999 2,132,191 $24.50 1.08% $.88 29 .25 .39 6.06 2.07 .11 .07 .05 3.59 .25 .08 $14.09 4.27 1.62 2.65 .25 $22.88 .04 $22.84 24.24 $1.40 Product B Per 100 kgs. $1,570 $1.53 503 405 .39 439 .42 6,107 5.92 2,124 2.06 251 .24 130 .12 82 .08 4,716 4.58 485 .46 150 .15 $16,962 $16.44 4,582 4.44 1,300 1.26 4,274 4.16 409 .39 $27,527 $26.69 53 .05 $27,474 $26.64 25,996 25.23 (1,478) ($1.41) 1,029,654 $25.80 2.14$ Product C Per 100 kgs. $1,882 $1.90 401 .40 534 .53 458 .46 6,879 6.97 2,309 2.33 302 .31 106 .10 75 .08 4,851 4.91 350 .36 104 .10 $18,249 $18.45 4,701 4.76 1,783 1.80 3,658 3.70 539 .53 $28,879 $29.19 51 .05 $28,879 $29.19 26,670 27.03 ($2,209) ($2.16) 986,974 $27.50 1.74% $5,324 1,525 1,463 1,733 5621 25,921 8,846 773 394 266 17,208 1,360 438 $65,251 18,383 6,534 13,591 1,472 $105,231 205 $105,026 104,338 ($688) X X X $ Value of sales $ Value of sales Value of equipment Value of equipment X $ Value of sales Sales (Net) Profit (Loss) Unit Sales (100 kgs.) Quoted Selling Price Per Unit Cash Discount Taken % of Selling Price) 1.48% Exhibit 3: Accounting Department's Commentary on Costs Direct Labor: Variable. Union shop at going community rates. No abnormal demands foreseen. It may be assumed that direct labor dollars are an adequate measure of capacity utilization. Compensation Insurance: Variable. Five percent of direct and indirect labor is an accurate estimate Materials: Variable. Exhibit 2 figures are accurate. Includes waste allowances. Purchase are at market prices Power: Variable. Rates are fixed. Use varies with activity. Averages per Exhibit 2 are accurate. Supplies: Variable. Exhibit 2 figures are accurate. Supplies bought at market prices. Repairs: Variable. Varies as volume changes within normal operation range. Lower and upper limits are fixed. General Administrative, Selling Expense, Indirect Labor, Interest, and Other income: These items are almost non-variable. They can be changed, of course, by management decision. Cash Discount: Almost non-variable. Average cash discount taker are consistent from year to year. Percentages in Exhibit 2 are accurate. Light and Heat: Almost non-variable. Heat varies slightly with fuel cost changes. Light a fixed item regardless of level of production. Property Taxes: Almost non-variable. Under the lease terms superior pays the taxes; assessed valuations have been constant; the rate has risen slowly. Any change in the near future will be small and independent of production volume. Rent: Non-variable. Lease has 12 years to run Building service: Non-variable. At normal business level, variances are small. Property Insurance: Non-variable. Three-year policy with fixed premium. Depreciation: Non-variable. Fixed dollar total. Exhibit 4 Income statement by products and departments at standard and total company variances from January 1 to June 30, 2015 (Thousands $ except per 100 kgs.) Item Product A Standard Total at Per 100 kgs. Standard Total Standard $2,919 Total Actual $2,660 349 201 839 770 793 919 2.33 13,751 4,698 435 205 .05 147 Rent $.88 $877 Property Tax .29 299 Property Insurance .25 249 Compensation Insurance .39 389 Direct Labor 6.06 6,041 Indirect Labor 2.07 2,063 Power .11 109 Light & Heat .07 70 Building Service 50 Materials 3.59 3,579 Supplies .25 239 Repairs .08 79 Total $14.09 $14,034 Selling Expense 4.27 4,257 General Administrative 1.62 1,615 Depreciation 2.65 2,642 Interest .25 249 Total Cost $22.88 $22,797 Less: Other Income .04 40 $22.84 $22.757 Actual Sales (net) 24.24 24,164 Profit Loss $1.40 $1,407 Unit Sales (100 kgs.) 996,859 a: Actual unit sales times standard net revenue per unit Product B Standard Total at Per 100 kgs. Standard $1.53 $1,090 .49 -39 278 .42 299 5.92 4,216 2.06 1,467 .24 171 .12 85 .08 57 4.58 3,216 .46 328 .15 107 $16.44 $11,708 4.44 3,162 1.26 897 4.16 2,962 .39 278 $26.69 $19,007 .05 36 $26.64 $18,971 25.23 17,961 ($1.41) ($1,010) 712,102 Product C Standard Total at Per 100 kgs. Standard $1.90 $952 .40 .53 266 .46 231 6.97 3,496 1,168 .31 155 .10 50 .08 40 4.91 2,461 .36 180 .10 50 $18.45 $9,248 4.76 2,336 1.80 902 3.70 1,855 .53 266 $29.24 $14,657 .05 25 $29.19 $14,632 27.03 13,550 ($2.16) ($1,082) 501,276 9,301 747 236 $34,990 9,805 3,414 7,459 793 $56,461 101 $56,360 55,657 ($685) 732 917 13,820 4,485 432 200 107 9,232 750 251 $34,406 9,830 3,289 6,817 730 $55,072 110 $54,962 55,675 $713 AB Total $ 51,672 $25,996 $26,670 $104,338 344 647 12,937 7,641 6,877 4,851 302 220 305 6,107 4,716 251 485 150 $ 12,014 $ 13,982 525 184 $ 22,154 $ 29,518 350 1,296 25,921 17,208 773 1,360 438 $ 46.996 $57,342 104 $ 12.828 $ 13,842 Sales (net) Variable Costs Compensation Insurance Direct Labor Materials Power Supplies Repairs Total Variable costs Contribution Fixed Expenses Compensation Insurance ($1,733-1,206) Ront Proporty Taxos Property Insurance Indirect Labor Light and Heat Building Service Selling Expense General Administration Depreciation Interest Total Fixed Expenses Other Income Net Loss 437 5,324 1,525 1,463 8,846 394 266 18,383 6,534 13,591 1.472 $ 58,235 205 $ 689
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started