REWORD THE TEXT TO 6TH GRADE LEVEL DO NOT USE ONLINE SOURCES PLEASE
Obama was expected to give his keynote speech on Tuesday night 27 July. Before his presentation, some Obama advisors were worried, because it was the first time he had used a teleprompter.Obama soon went into a brief autobiographical session talking about his grand-dad made a living by working as a servant for the British, to his own dad who had got a scholarship so that he could come to the United States. Then talked about his mother's family, explaining his grandfather fighting in World War II under Patton while his grandmother was working and taking care of his mom..
He spoke about the simple librety enunciated in the Declaration of Independence, and he said in the 2004 election he thought was a time to reassure these values and remember that "We have more work to do." He then went on to mention several Americans he met who weren’t doing good with jobs, healthcare, and education, saying that "they don't expect the government to fix all their problems, but they hope, deep in their hearts, that with just a small change in priorities, we can ensure that every child in America has a fair shot at life and that the doors in opportunity remain open to all.In the next piece of his speech, Obama addressed John Kerry, stating his core principles and convictions on a variety of topics, interrupted by a tale of a young Marine he had met and affirmed that when military action is conducted, the families and soldiers involved must be looked after and that there is a duty to never go to war without adequate troops to win the war, secure peace and gain world respect. "Obama subsequently returned to Kerry and expressed his determination to keep America safe. Obama then discussed the notions of community and cohesion in America that individuals suffering elsewhere affects us even though we are not directly involved in it.
In: Economics
In: Finance
Revenue Recognition - Percentage of Completion - Project Instructions, Spring 2018
One of your clients is a large regional construction company. The company has many long-term projects in the works. The spreadsheet you are given contains some information about these jobs. Some of the jobs began last year and continue into the current year, so they exist on both tabs. The projects are in various phases of construction; some of which were completed during the current year.
You've been asked by your firm to analyze the data and prepare the following:
1) Complete the revenue recognition process by adding the necessary calculations into the blank columns F-J and L-M on the Current Year and Prior Year tabs and populate the data for all rows. It is expected that you look back at the text for definitions and to remind yourself of the percentage of completion method prior to asking questions.
Current year:
| Job | Description | Final Est Contract Amount | Costs To Date | Total Est Cost @ Completion | Est to Complete | Est GP @ Completion | Cur % Comp | GP TO DATE | Earned Rev To Date | Billings To Date | Costs and profit in Excess of Billings | Billings in Excess of Costs and Profits | Phase | Revenue to Book |
| 1959 | MISC | 7,465,878 | 7,247,171 | 7,247,523 | 7,465,878 | |||||||||
| 1960 | MISC | 7,959,254 | 7,666,799 | 7,706,890 | 7,959,254 | |||||||||
| 1968 | MISC | 46,201,877 | 44,283,436 | 45,810,921 | 44,435,743 | |||||||||
| 1029 | MISC | 6,770,156 | 7,187,389 | 7,169,543 | 6,693,717 | |||||||||
| 1972 | MISC | 13,157,854 | 9,938,521 | 12,926,801 | 10,169,759 | |||||||||
| 1974 | MISC | 16,811,634 | 16,636,718 | 16,614,718 | 16,811,634 | |||||||||
| 1978 | MISC | 3,240,516 | 3,180,526 | 3,180,526 | 3,290,995 | |||||||||
| 1980 | MISC | 7,098,168 | 6,696,897 | 6,825,642 | 6,989,363 | |||||||||
| 1981 | MISC | 22,464,145 | 22,067,900 | 22,067,900 | 22,462,520 | |||||||||
| 1982 | MISC | 26,910,817 | 26,266,450 | 26,384,521 | 26,910,817 | |||||||||
| 1987 | MISC | 21,527,597 | 20,758,005 | 20,758,244 | 21,527,597 | |||||||||
| 1037 | MISC | 67,479 | 65,707 | 62,708 | 67,480 | |||||||||
| 1038 | MISC | 966,844 | 949,107 | 938,107 | 966,845 | |||||||||
| 1040 | MISC | 166,942 | 143,084 | 143,084 | 166,942 | |||||||||
| 1041 | MISC | 700,689 | 598,903 | 598,804 | 700,689 | |||||||||
| 1042 | MISC | 346,721 | 251,917 | 292,629 | 346,721 | |||||||||
| 1043 | MISC | 1,079,159 | 1,079,159 | 1,079,159 | 1,079,190 | |||||||||
| 1044 | MISC | 510,939 | 393,910 | 411,390 | 503,188 | |||||||||
| 1991 | MISC | 21,145,050 | 21,511,616 | 21,511,616 | 21,045,050 | |||||||||
| 1992 | MISC | 3,564,527 | 3,519,267 | 3,519,270 | 3,572,179 | |||||||||
| 1994 | MISC | 7,789,575 | 7,516,192 | 7,552,450 | 7,789,575 | |||||||||
| 1995 | MISC | 13,320,841 | 12,531,906 | 12,784,219 | 13,006,125 | |||||||||
| 1996 | MISC | 13,535,310 | 12,331,088 | 13,178,122 | 13,029,481 | |||||||||
| 1997 | MISC | 2,729,944 | 2,657,501 | 2,661,842 | 2,729,944 | |||||||||
| 1998 | MISC | 7,341,782 | 5,274,107 | 7,161,359 | 5,440,960 | |||||||||
| 1999 | MISC | 13,327,661 | 12,510,677 | 13,078,905 | 12,745,737 | |||||||||
| 2000 | MISC | 3,479,901 | 3,391,393 | 3,392,850 | 3,479,901 | |||||||||
| 2001 | MISC | 8,880,861 | 4,967,713 | 8,671,818 | 4,897,156 | |||||||||
| 2002 | MISC | 5,407,348 | 5,097,975 | 5,232,080 | 5,278,519 | |||||||||
| 2003 | MISC | 6,057,682 | 4,689,023 | 5,835,790 | 5,088,472 | |||||||||
| 2004 | MISC | 3,388,921 | 3,327,035 | 3,371,364 | 3,388,921 | |||||||||
| 2005.01 | MISC | 1,541,229 | 651,078 | 1,488,653 | 677,958 | |||||||||
| 2005.02 | MISC | 1,382,138 | 494,118 | 1,382,138 | 494,118 | |||||||||
| 2005.03 | MISC | 109,951 | 109,951 | 109,951 | 109,727 | |||||||||
| 2006 | MISC | 6,243,535 | 4,063,446 | 6,138,535 | 4,160,662 | |||||||||
| 2007 | MISC | 12,234,190 | 9,906,338 | 11,918,995 | 10,139,456 | |||||||||
| 1045 | MISC | 1,273,869 | 473,014 | 1,178,757 | 558,982 | |||||||||
| 1047 | MISC | 2,000,000 | 1,532,818 | 1,934,051 | 1,498,479 | |||||||||
| 1048 | MISC | 289,132 | 280,188 | 277,088 | 289,132 | |||||||||
| 1050 | MISC | 337,399 | 330,095 | 337,399 | 287,285 | |||||||||
| 1051 | MISC | 103,714 | 91,533 | 93,701 | 95,000 | |||||||||
| 1052 | MISC | 1,627,500 | 898,738 | 1,532,500 | 867,785 | |||||||||
| 1053 | MISC | 587,936 | 119,971 | 534,936 | 59,133 | |||||||||
| 1054 | MISC | 272,187 | 93,423 | 232,095 | 139,406 | |||||||||
| 1055 | MISC | 1,368 | 1,189 | 1,189 | - | |||||||||
| 1056 | MISC | 6,500 | 3,241 | 5,800 | 6,500 | |||||||||
| 1057 | MISC | 160,254 | 3,979 | 151,254 | 53,418 | |||||||||
| 2008 | MISC | 12,027,982 | 11,540,290 | 11,792,749 | 11,624,921 | |||||||||
| 2010 | MISC | 3,564,023 | 3,442,746 | 3,482,704 | 3,510,318 | |||||||||
| 2011 | MISC | 3,571,024 | 3,172,365 | 3,471,558 | 3,263,051 | |||||||||
| 2012 | MISC | 8,863,236 | 3,382,784 | 8,483,236 | 3,484,037 | |||||||||
| 2013 | MISC | 17,562,203 | 3,043,921 | 17,237,203 | 3,175,529 | |||||||||
| 2014 | MISC | 3,469,196 | 1,713,032 | 3,379,313 | 2,240,054 | |||||||||
| 2015 | MISC | 6,270,919 | 1,759,495 | 6,111,394 | 2,468,135 | |||||||||
| 2017 | MISC | 906,972 | 870,069 | 870,070 | 907,612 | |||||||||
| 2018 | MISC | 16,981,831 | 20,841 | 16,646,831 | 123,250 | |||||||||
| 2019 | MISC | 12,514,813 | 734,163 | 12,188,248 | 825,637 | |||||||||
| 2020 | MISC | 12,215,549 | 35,797 | 11,860,853 | - | |||||||||
| 2021 | MISC | 5,475,364 | 82,553 | 5,575,364 | 226,051 | |||||||||
| 2022 | MISC | 14,031,862 | 90,859 | 13,669,617 | - | |||||||||
| 2023 | MISC | - | 831 | - | - | |||||||||
| 2024 | MISC | - | - | - | - | |||||||||
| 2025 | MISC | 5,399,500 | - | 5,243,500 | - | |||||||||
| 2026 | MISC | 1,030,000 | 8,317 | 1,000,000 | - | |||||||||
| 2027 | MISC | 5,700,000 | - | 5,586,000 | - | |||||||||
| 1941 | MISC | 11,700,949 | 11,306,077 | 11,306,077 | 11,700,949 | |||||||||
| 1951 | MISC | 430,558 | 429,853 | 429,853 | 430,558 | |||||||||
| 1958 | MISC | 5,113,424 | 5,012,706 | 5,012,706 | 5,113,424 | |||||||||
| 1966 | MISC | 2,746,125 | 2,749,328 | 2,749,328 | 2,746,125 | |||||||||
| 1027 | MISC | 297,482 | 290,349 | 290,349 | 297,482 | |||||||||
| 1028 | MISC | 1,462,324 | 1,478,580 | 1,478,580 | 1,462,324 | |||||||||
| 1030 | MISC | 819,108 | 709,272 | 709,272 | 819,108 | |||||||||
| 1971 | MISC | 5,439,533 | 5,205,826 | 5,205,826 | 5,439,533 | |||||||||
| 1973 | MISC | 6,997,612 | 7,190,985 | 7,190,985 | 6,997,612 | |||||||||
| 1975 | MISC | 3,541,081 | 3,412,625 | 3,412,625 | 3,541,081 | |||||||||
| 1977 | MISC | 2,111,870 | 2,060,093 | 2,060,093 | 2,111,870 | |||||||||
| 1979 | MISC | 3,883,384 | 4,095,004 | 4,095,004 | 3,883,384 | |||||||||
| 1983 | MISC | 8,416,157 | 8,228,116 | 8,228,116 | 8,416,157 | |||||||||
| 1984 | MISC | 10,454,724 | 10,201,631 | 10,201,631 | 10,454,724 | |||||||||
| 1986 | MISC | 7,120,629 | 6,862,156 | 6,862,156 | 7,120,629 | |||||||||
| 1988 | MISC | 244,433 | 190,944 | 190,944 | 244,433 | |||||||||
| 1989 | MISC | 6,573,752 | 6,410,702 | 6,410,702 | 6,573,752 | |||||||||
| 1031 | MISC | 356,254 | 331,883 | 331,883 | 356,254 | |||||||||
| 1032 | MISC | 1,262,853 | 1,261,237 | 1,261,237 | 1,262,853 | |||||||||
| 1033 | MISC | 2,184,271 | 1,668,446 | 1,668,446 | 2,184,271 | |||||||||
| 1034 | MISC | 276,190 | 276,190 | 276,190 | 276,190 | |||||||||
| 1035 | MISC | 221,826 | 206,835 | 206,835 | 221,826 | |||||||||
| 1036 | MISC | 112,637 | 112,629 | 112,629 | 112,637 | |||||||||
| 1039 | MISC | 73,237 | 56,173 | 56,173 | 73,237 | |||||||||
| 1990 | MISC | 4,753,810 | 4,682,621 | 4,682,621 | 4,753,810 | |||||||||
| 1993 | MISC | 2,419,387 | 2,381,836 | 2,381,836 | 2,419,387 | |||||||||
| 1046 | MISC | 167,393 | 156,353 | 156,353 | 167,393 | |||||||||
| 1049 | MISC | 204,076 | 177,714 | 177,714 | 204,076 | |||||||||
| 540,556,527 | 410,834,439 | 529,232,641 | - | - | - | - | - | 420,711,067 | - | - |
Prior Yr:
| Job | Description | Final Est Contract Amount | Costs To Date | Total Est Cost @ Completion | Est to Complete | Est GP @ Completion | Cur % Comp | GP TO DATE | Earned Rev To Date | Billings To Date | Costs and profit in Excess of Billings | Billings in Excess of Costs and Profits |
| 1977 | MISC | 2,090,204 | 2,058,488 | 2,060,000 | 2,090,204 | |||||||
| 1966 | MISC | 2,740,196 | 2,747,956 | 2,750,000 | 2,740,196 | |||||||
| 1951 | MISC | 429,853 | 429,853 | 429,853 | 430,558 | |||||||
| 1988 | MISC | 238,471 | 190,944 | 190,944 | 236,471 | |||||||
| 1027 | MISC | 297,482 | 290,349 | 290,349 | 277,482 | |||||||
| 1028 | MISC | 1,459,971 | 1,468,711 | 1,468,711 | 1,449,843 | |||||||
| 1030 | MISC | 819,108 | 707,310 | 707,310 | 805,483 | |||||||
| 1979 | MISC | 3,883,384 | 4,094,330 | 4,095,000 | 3,883,384 | |||||||
| 1036 | MISC | 112,637 | 112,618 | 112,637 | 112,637 | |||||||
| 1973 | MISC | 6,997,612 | 7,189,463 | 7,190,800 | 6,997,612 | |||||||
| 1974 | MISC | 16,396,834 | 16,098,923 | 16,107,664 | 15,945,665 | |||||||
| 1958 | MISC | 5,113,424 | 5,008,868 | 5,012,893 | 5,111,033 | |||||||
| 1984 | MISC | 10,458,619 | 10,191,522 | 10,204,882 | 10,453,214 | |||||||
| 1975 | MISC | 3,541,081 | 3,410,943 | 3,415,946 | 3,544,656 | |||||||
| 1941 | MISC | 11,700,949 | 11,277,526 | 11,305,949 | 11,700,949 | |||||||
| 1971 | MISC | 5,439,533 | 5,205,826 | 5,223,433 | 5,439,533 | |||||||
| 1960 | MISC | 7,959,254 | 7,633,497 | 7,706,890 | 7,959,254 | |||||||
| 1983 | MISC | 8,363,611 | 8,084,939 | 8,164,134 | 8,286,417 | |||||||
| 1978 | MISC | 3,240,516 | 3,146,456 | 3,180,516 | 3,185,418 | |||||||
| 1993 | MISC | 2,419,988 | 2,357,037 | 2,384,988 | 2,419,387 | |||||||
| 1035 | MISC | 220,950 | 205,377 | 208,000 | 217,330 | |||||||
| 1034 | MISC | 278,849 | 274,429 | 278,849 | 253,479 | |||||||
| 1980 | MISC | 7,098,168 | 6,710,276 | 6,825,642 | 6,945,454 | |||||||
| 1990 | MISC | 4,711,151 | 4,598,024 | 4,678,950 | 4,626,775 | |||||||
| 1989 | MISC | 6,661,286 | 6,383,190 | 6,497,850 | 6,556,992 | |||||||
| 1986 | MISC | 7,162,422 | 6,712,121 | 6,920,598 | 6,884,933 | |||||||
| 1037 | MISC | 68,879 | 56,897 | 61,400 | 67,480 | |||||||
| 1031 | MISC | 378,974 | 330,684 | 360,200 | 356,254 | |||||||
| 1981 | MISC | 22,282,269 | 20,016,392 | 22,051,402 | 20,470,769 | |||||||
| 1992 | MISC | 3,461,496 | 2,945,587 | 3,404,937 | 2,955,664 | |||||||
| 1991 | MISC | 20,138,168 | 16,559,725 | 19,452,425 | 17,234,825 | |||||||
| 1033 | MISC | 2,104,258 | 1,417,904 | 1,710,084 | 1,754,574 | |||||||
| 1029 | MISC | 6,674,301 | 5,588,592 | 6,912,342 | 5,447,628 | |||||||
| 1994 | MISC | 6,194,488 | 4,644,358 | 6,008,863 | 4,857,414 | |||||||
| 1032 | MISC | 1,327,931 | 1,025,867 | 1,327,931 | 987,505 | |||||||
| 1959 | MISC | 7,510,509 | 5,122,011 | 7,291,759 | 5,241,333 | |||||||
| 1987 | MISC | 21,977,597 | 14,703,934 | 21,524,620 | 15,315,793 | |||||||
| 1997 | MISC | 2,601,318 | 1,489,455 | 2,543,216 | 1,709,841 | |||||||
| 1039 | MISC | 72,622 | 36,578 | 62,622 | 47,226 | |||||||
| 1972 | MISC | 9,300,000 | 4,670,647 | 9,097,073 | 5,175,762 | |||||||
| 1982 | MISC | 28,064,434 | 13,169,455 | 27,648,138 | 14,477,824 | |||||||
| 1968 | MISC | 44,263,879 | 16,221,792 | 43,722,923 | 16,494,611 | |||||||
| 1996 | MISC | 8,000,000 | 2,586,688 | 7,825,000 | 2,743,271 | |||||||
| 1041 | MISC | 701,835 | 54,041 | 633,948 | 112,435 | |||||||
| 1038 | MISC | 835,000 | 63,697 | 755,000 | 75,493 | |||||||
| 1040 | MISC | 166,121 | 11,069 | 143,721 | 35,000 | |||||||
| 2000 | MISC | 3,460,051 | 248,325 | 3,375,675 | 206,325 | |||||||
| 1999 | MISC | 11,950,980 | 547,127 | 11,651,589 | 586,828 | |||||||
| 1995 | MISC | 13,371,080 | 368,910 | 12,831,080 | 383,667 | |||||||
| 2002 | MISC | 3,500,000 | 66,826 | 3,411,000 | 62,565 | |||||||
| 2003 | MISC | 4,624,038 | 54,191 | 4,461,051 | 0 | |||||||
| 2001 | MISC | 8,437,049 | 30,923 | 8,235,633 | 289,215 | |||||||
| 1043 | MISC | 628,920 | 1,801 | 628,920 | 1,801 | |||||||
| 2006 | MISC | 6,000,000 | 1,739 | 5,820,000 | 0 | |||||||
| 2004 | MISC | 3,440,871 | 828 | 3,330,871 | 0 | |||||||
| 1998 | MISC | 5,500,000 | 875 | 5,375,000 | 0 | |||||||
| 2007 | MISC | 12,100,481 | 0 | 11,789,465 | 0 | |||||||
| 2005 | MISC | 0 | 0 | 0 | 0 | |||||||
| 1042 | MISC | 302,473 | 0 | 268,381 | 0 | |||||||
| 1044 | MISC | 0 | 0 | 0 | 0 | |||||||
| 1925 | MISC | 12,598,919 | 11,943,651 | 11,943,651 | 12,598,919 | |||||||
| 1932.01 | MISC | 38,775,649 | 37,277,096 | 37,277,096 | 38,775,649 | |||||||
| 1932.02 | MISC | 15,209,443 | 14,612,438 | 14,612,438 | 15,209,443 | |||||||
| 1933 | MISC | 17,332,336 | 16,836,298 | 16,836,298 | 17,332,336 | |||||||
| 1940 | MISC | 2,908,333 | 2,577,844 | 2,577,844 | 2,908,333 | |||||||
| 1023 | MISC | 110,178 | 110,174 | 110,174 | 110,178 | |||||||
| 1944 | MISC | 6,010,630 | 5,769,964 | 5,769,964 | 6,010,630 | |||||||
| 1945 | MISC | 2,982,172 | 2,872,203 | 2,872,203 | 2,982,172 | |||||||
| 1949 | MISC | 3,552,127 | 3,314,044 | 3,314,044 | 3,552,127 | |||||||
| 1954 | MISC | 3,011,044 | 2,906,830 | 2,906,830 | 3,011,044 | |||||||
| 1961 | MISC | 4,403,166 | 4,250,089 | 4,250,089 | 4,403,166 | |||||||
| 1965 | MISC | 3,649,431 | 3,600,724 | 3,600,724 | 3,649,431 | |||||||
| 1967 | MISC | 3,256,442 | 3,158,722 | 3,158,722 | 3,256,442 | |||||||
| 1970 | MISC | 771,601 | 688,644 | 688,644 | 771,601 | |||||||
| 1026 | MISC | 185,392 | 156,420 | 156,420 | 185,392 | |||||||
| 1976 | MISC | 7,990,442 | 7,796,645 | 7,796,645 | 7,990,442 | |||||||
| 1985 | MISC | 4,962,349 | 4,826,861 | 4,826,861 | 4,962,349 | |||||||
| 506,985,229 | 351,324,541 | 493,827,704 | 0 | 0 | 0 | 0 | 363,355,116 | 0 | 0 |
In: Accounting
Is this correct for statement of cashflow indirect method?
|
Panther Marine Corporation |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| For the Years Ended June 30, 2016 and 2017 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Instructions: Below are the adjusted trial balances for the years ended June 30, 2016 and 2017. The outlined cells in the changes columns MUST be completed for the statement of cash flows. Use formulas to find the debit OR credit changes in identfied cells. USE the June 30, 2017 adjusted trial balance columns to create the financial statements. DO NOT COMPLETE CELLS THAT ARE GRAYED OUT. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| June 30, 2016 | June 30, 2017 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Adjusted | Adjusted | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Trial Balance | Changes | Trial Balance | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Acct. No. | Account Title | Dr. | Cr. | Debit | Credit | Dr. | Cr | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 100 | Cash | 562,480.00 | 183,490.91 | 378,989.09 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 102 | Accounts Receivable | 822,633.00 | 67,233.00 | 755,400.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 103 | Allowance for Doubtful Accounts | 25,643.00 | 5,826.11 | 19,816.89 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 104 | Merchandise Inventory | 440,980.00 | 94,630.00 | 346,350.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 105 | Estimated Returns Inventory | 56,450.00 | 12,909.00 | 43,541.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 106 | Office Supplies | 1,250.00 | 1,215.00 | 2,465.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 107 | Prepaid Insurance | 12,500.00 | 2,000.00 | 10,500.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 120 | Investments - Trading | 45,000.00 | 15,000.00 | 60,000.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 121 | Investments - Available for Sale | 14,650.00 | 11,800.00 | 26,450.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 122 | Investments - Held to Maturity | 23,850.00 | 16,155.01 | 40,005.01 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 123 | Valuation Allowance | 27,000.00 | 8,000.00 | 35,000.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 140 | Land | 1,743,777.65 | 761,777.36 | 2,505,555.01 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 145 | Building | 1,893,723.48 | 50,000.00 | 1,843,723.48 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 146 | Accumulated Depreciation - Building | 1,504,955.01 | 1,500,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 151 | Equipment | 51,000.00 | 10,000.00 | 61,000.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 152 | Accumulated Depreciation - Equipment | 28,000.00 | 30,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 153 | Office Furniture | 32,500.00 | 10,000.00 | 22,500.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 154 | Accumulated Depreciation - Office Furniture | 3,500.00 | 4,500.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 201 | Accounts Payable | 1,156,000.00 | 251,150.00 | 904,850.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 202 | Wages Payable | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 203 | Interest Payable | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 204 | Dividends Payable | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 205 | Unearned Rent | 6,000.00 | 2,000.00 | 4,000.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 206 | Customer Refunds Payable | 35,682.00 | 6,654.40 | 29,027.60 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 250 | Notes Payable | 12,000.00 | 200,000.00 | 212,000.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 251 | Bonds Payable | 200,000.00 | 200,000.00 | 400,000.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 252 | Premium on Bonds Payable | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 253 | Discount on Bonds Payable | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 252 | Mortgage (Warehouse) Payable | 248,000.00 | 50,000.00 | 198,000.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 300 | Common Stock, $1 Par, 100,000 Authorized; 65,500 shares Issued/Outstanding | 50,000.00 | 15,500.00 | 65,500.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 301 | Paid In Capital - Excess of Par | 356,000.00 | 154,544.99 | 510,544.99 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 330 | Retained Earnings | 2,388,379.11 | 2,140,014.12 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 331 | Cash Dividends | - | 100,000.00 | 100,000.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 340 | Treasury Stock | 38,000.00 | 20,000.00 | 18,000.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 341 | Unrealized (Gain) Loss Available for Sale Securities | - | - | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 500 | Sales | 1,142,580.00 | 1,468,529.98 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 600 | Cost of Goods Sold | 450,199.00 | 482,159.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 700 | Wage Expense (hourly workers) | 594,515.01 | 399,500.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 701 | Salaries Expense (Exempt Staff) | 89,000.00 | 129,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 702 | Marketing Expense | 65,000.00 | 75,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 703 | Travel and Entertainment Expense | 525.00 | 925.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 704 | Bad Debt Expense | 5,816.88 | 9,816.88 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 705 | Property Tax Expense | 111,104.10 | - | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 706 | Office Maintenance & Repair Expense | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 707 | Legal Expenses | - | 5,400.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 708 | Insurance Expense | 1,500.00 | 3,500.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 709 | Utilities Expense | 48,985.00 | 68,624.12 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 710 | Office Supplies Expense | 400.00 | 735.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 711 | Telecommunications Expense | - | 100.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 712 | Depreciation Expense - Building | - | 100,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 713 | Depreciation Expense - Equipment | 4,000.00 | 2,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 714 | Depreciation Expense - Office Furniture | 500.00 | 1,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 800 | Rent Income | - | 2,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 801 | Unrealized Gain - Trading Securities | - | 6,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 802 | Realized Gain - Investment Securities | - | 51,955.01 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 900 | Interest Expense | 5,400.00 | 12,500.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 901 | Unrealized Loss - Trading Securities | 10,000.00 | 68,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 902 | Realized Loss - Investment Securities | 4,000.00 | 9,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total | 7,156,739.120 | 7,156,739.120 | 7,581,738.590 | 7,581,738.590 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1,390,944.99 | 1,142,580.00 | 1,367,260.00 | 1,528,484.99 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Net Income (Loss) | (248,364.99) |
|
161,224.99 |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Absorption costing does not distinguish between variable and fixed costs. All manufacturing costs are included in the cost of goods sold.
|
Saxon, Inc. |
|
Absorption Costing Income Statement |
|
For the Year Ended December 31 |
|
1 |
Sales |
$1,125,000.00 |
|
|
2 |
Cost of goods sold: |
||
|
3 |
Beginning inventory |
$0.00 |
|
|
4 |
Cost of goods manufactured |
840,000.00 |
|
|
5 |
Ending inventory |
(210,000.00) |
|
|
6 |
Total cost of goods sold |
630,000.00 |
|
|
7 |
Gross profit |
$495,000.00 |
|
|
8 |
Selling and administrative expenses |
275,000.00 |
|
|
9 |
Income from operations |
$220,000.00 |
Variable Statement
Under variable costing, the cost of goods manufactured includes only variable manufacturing costs. This type of income statement includes a computation of manufacturing margin.
|
Saxon, Inc. |
|
Variable Costing Income Statement |
|
For the Year Ended December 31 |
|
1 |
Sales |
$1,125,000.00 |
|
|
2 |
Variable cost of goods sold: |
||
|
3 |
Beginning inventory |
$0.00 |
|
|
4 |
Variable cost of goods manufactured |
600,000.00 |
|
|
5 |
Ending inventory |
(150,000.00) |
|
|
6 |
Total variable cost of goods sold |
450,000.00 |
|
|
7 |
Manufacturing margin |
$675,000.00 |
|
|
8 |
Variable selling and administrative expenses |
210,000.00 |
|
|
9 |
Contribution margin |
$465,000.00 |
|
|
10 |
Fixed costs: |
||
|
11 |
Fixed manufacturing costs |
$240,000.00 |
|
|
12 |
Fixed selling and administrative expenses |
65,000.00 |
|
|
13 |
Total fixed costs |
305,000.00 |
|
|
14 |
Income from operations |
$160,000.00 |
Manufacturing Decisions
Shaded cells have feedback.
Whenever the units manufactured differ from the units sold, finished goods inventory is affected. In analyzing income from operations, such increases and decreases could be misinterpreted as operating efficiencies or inefficiencies. Each decision-making situation should be carefully analyzed in deciding whether absorption or variable costing reporting would be more useful.
All costs are controllable in the long run by someone within a business. For a given level of management, costs may be controllable costs or noncontrollable costs.
The production manager for Saxon, Inc. is worried because the company is not showing a high enough profit. Looking at the income statements on the Absorption Statement panel and the Variable Statement panel, he notices that the net income is higher on the absorption cost income statement. He is considering manufacturing another 10,000 units, up to the company’s capacity for manufacturing, in the coming year. He reasons that this will boost net income and satisfy the company’s owner that the company is sufficiently profitable. Although the total units manufactured changes, assume that total fixed costs, unit variable costs, unit sales price, and the sales levels are the same. Complete questions (1)-(4) that follow. If the answer is zero, enter "0".
1. Use the income statements on the Absorption Statement and Variable Statement panels to complete the following table for the original production level. Then prepare similar income statements at a production level 10,000 units higher and add that information to the table. Assume that total fixed costs, unit variable costs, unit sales price, and the sales levels are the same at both production levels.
|
Income From Operations |
|||
|---|---|---|---|
| Original | Original | Additional | Additional |
| Production | Production | 10,000 | 10,000 |
| Level-Absorption | Level-Variable | Units-Absorption | Units-Variable |
Points:
2 / 4
Feedback
2. What is the change in net income from producing 10,000 additional units under absorption costing?
Points:
0 / 1
Feedback
3. What is the change in net income from producing 10,000 additional units under variable costing?
Points:
0 / 1
Feedback
4. What would be your recommendation to the production manager?
Do not produce the extra 10,000 units. The increase in net income under absorption costing is due to fixed manufacturing costs being held in inventory, and the additional inventory will lead to higher handling, storage, financing, and obsolescence costs.
Produce the extra 10,000 units. Net income will be increased, and the production manager will receive praise for creating higher profits.
Do not produce the extra 10,000 units. Net income does not change under absorption costing when the additional units are produced.
Produce the extra 10,000 units. It's always a good idea to have extra units on hand and keep the factory operating at capacity, even if all the units are not sold.
Points:
1 / 1
Feedback
Contribution Margin Data
For planning and control purposes, managers often compare planned and actual contribution margin. Variable costing is used as a basis for such analyses.
Examine the following contribution margin data, and then complete the Contribution Margin Analysis panel.
| Saxon, Inc. | ||
| Contribution Margin Data Schedule | ||
| Actual | Planned | |
| Sales | $1,125,000 | $1,190,000 |
| Variable cost of goods sold | $450,000 | $462,000 |
| Variable selling and administrative expenses | 210,000 | 154,000 |
| Total | $660,000 | $616,000 |
| Contribution margin | $465,000 | $574,000 |
| Number of units sold | 15,000 | 14,000 |
| Per unit: | ||
| Sales price | $75.00 | $85.00 |
| Variable cost of goods sold | 30.00 | 33.00 |
| Variable selling and administrative expenses | 14.00 | 11.00 |
Contribution Margin Analysis
Shaded cells have feedback.
Contribution margin analysis focuses on explaining the differences between planned and actual contribution margins, considering the quantity factor and the unit price factor.
After reviewing the data on the Contribution Margin Data panel, complete the following contribution margin analysis. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Question not attempted.
Score: 0/44
|
Saxon, Inc. |
|
Contribution Margin Analysis |
|
For the Year Ended December 31 |
|
1 |
Planned contribution margin |
||
|
2 |
Effect of changes in sales: |
||
|
3 |
Sales quantity factor |
||
|
4 |
Unit price factor |
||
|
5 |
Total effect of changes in sales |
||
|
6 |
Effect of changes in variable cost of goods sold: |
||
|
7 |
Variable cost quantity factor |
||
|
8 |
Unit cost factor |
||
|
9 |
Total effect of changes in variable cost of goods sold |
||
|
10 |
Effect of changes in selling and administrative expenses: |
||
|
11 |
Variable cost quantity factor |
||
|
12 |
Unit cost factor |
||
|
13 |
Total effect of changes in selling and administrative expenses |
||
|
14 |
Actual contribution margin |
In: Accounting
Please journal and manufaturing decisions!
Absorption costing does not distinguish between variable and fixed costs. All manufacturing costs are included in the cost of goods sold.
|
Saxon, Inc. |
|
Absorption Costing Income Statement |
|
For the Year Ended December 31 |
|
1 |
Sales |
$1,200,000.00 |
|
|
2 |
Cost of goods sold: |
||
|
3 |
Beginning inventory |
$0.00 |
|
|
4 |
Cost of goods manufactured |
800,000.00 |
|
|
5 |
Ending inventory |
(160,000.00) |
|
|
6 |
Total cost of goods sold |
640,000.00 |
|
|
7 |
Gross profit |
$560,000.00 |
|
|
8 |
Selling and administrative expenses |
289,000.00 |
|
|
9 |
Income from operations |
$271,000.00 |
Under variable costing, the cost of goods manufactured includes only variable manufacturing costs. This type of income statement includes a computation of manufacturing margin.
|
Saxon, Inc. |
|
Variable Costing Income Statement |
|
For the Year Ended December 31 |
|
1 |
Sales |
$1,200,000.00 |
|
|
2 |
Variable cost of goods sold: |
||
|
3 |
Beginning inventory |
$0.00 |
|
|
4 |
Variable cost of goods manufactured |
560,000.00 |
|
|
5 |
Ending inventory |
(112,000.00) |
|
|
6 |
Total variable cost of goods sold |
448,000.00 |
|
|
7 |
Manufacturing margin |
$752,000.00 |
|
|
8 |
Variable selling and administrative expenses |
224,000.00 |
|
|
9 |
Contribution margin |
$528,000.00 |
|
|
10 |
Fixed costs: |
||
|
11 |
Fixed manufacturing costs |
$240,000.00 |
|
|
12 |
Fixed selling and administrative expenses |
65,000.00 |
|
|
13 |
Total fixed costs |
305,000.00 |
|
|
14 |
Income from operations |
$223,000.00 |
/manufacturing decisions
Whenever the units manufactured differ from the units sold,
finished goods inventory is affected. In analyzing income from
operations, such increases and decreases could be misinterpreted as
operating efficiencies or inefficiencies. Each decision-making
situation should be carefully analyzed in deciding whether
absorption or variable costing reporting would be more useful.
All costs are controllable in the long run by someone within a business. For a given level of management, costs may be controllable costs or noncontrollable costs.
The production manager for Saxon, Inc. is worried because the company is not showing a high enough profit. Looking at the income statements on the Absorption Statement panel and the Variable Statement panel, he notices that the net income is higher on the absorption cost income statement. He is considering manufacturing another 10,000 units, up to the company’s capacity for manufacturing, in the coming year. He reasons that this will boost net income and satisfy the company’s owner that the company is sufficiently profitable. Although the total units manufactured changes, assume that total fixed costs, unit variable costs, unit sales price, and the sales levels are the same. Complete questions (1)-(4) that follow. If the answer is zero, enter "0".
1. Use the income statements on the Absorption Statement and Variable Statement panels to complete the following table for the original production level. Then prepare similar income statements at a production level 10,000 units higher and add that information to the table. Assume that total fixed costs, unit variable costs, unit sales price, and the sales levels are the same at both production levels.
|
Income From Operations |
|||
|---|---|---|---|
| Original | Original | Additional | Additional |
| Production | Production | 10,000 | 10,000 |
| Level-Absorption | Level-Variable | Units-Absorption | Units-Variable |
2. What is the change in net income from producing 10,000 additional units under absorption costing?
3. What is the change in net income from producing 10,000 additional units under variable costing?
4. What would be your recommendation to the production manager?
Produce the extra 10,000 units. It's always a good idea to have extra units on hand and keep the factory operating at capacity, even if all the units are not sold.
Do not produce the extra 10,000 units. Net income does not change under absorption costing when the additional units are produced.
Produce the extra 10,000 units. Net income will be increased, and the production manager will receive praise for creating higher profits.
Do not produce the extra 10,000 units. The increase in net income under absorption costing is due to fixed manufacturing costs being held in inventory, and the additional inventory will lead to higher handling, storage, financing, and obsolescence costs.
For planning and control purposes, managers often compare planned and actual contribution margin. Variable costing is used as a basis for such analyses.
Examine the following contribution margin data, and then complete the Contribution Margin Analysis panel.
|
Contribution margin data Saxon, Inc. |
||
| Contribution Margin Data Schedule | ||
| Actual | Planned | |
| Sales | $1,200,000 | $1,190,000 |
| Variable cost of goods sold | $448,000 | $462,000 |
| Variable selling and administrative expenses | 224,000 | 154,000 |
| Total | $672,000 | $616,000 |
| Contribution margin | $528,000 | $574,000 |
| Number of units sold | 16,000 | 14,000 |
| Per unit: | ||
| Sales price | $75.00 | $85.00 |
| Variable cost of goods sold | 28.00 | 33.00 |
| Variable selling and administrative expenses | 14.00 | 11.00 |
Contribution margin analysis focuses on explaining the differences between planned and actual contribution margins, considering the quantity factor and the unit price factor.
After reviewing the data on the Contribution Margin Data panel, complete the following contribution margin analysis. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
|
Saxon, Inc. |
|
Contribution Margin Analysis |
|
For the Year Ended December 31 |
|
1 |
Planned contribution margin |
||
|
2 |
Effect of changes in sales: |
||
|
3 |
Sales quantity factor |
||
|
4 |
Unit price factor |
||
|
5 |
Total effect of changes in sales |
||
|
6 |
Effect of changes in variable cost of goods sold: |
||
|
7 |
Variable cost quantity factor |
||
|
8 |
Unit cost factor |
||
|
9 |
Total effect of changes in variable cost of goods sold |
||
|
10 |
Effect of changes in selling and administrative expenses: |
||
|
11 |
Variable cost quantity factor |
||
|
12 |
Unit cost factor |
||
|
13 |
Total effect of changes in selling and administrative expenses |
||
|
14 |
Actual contribution margin |
In: Accounting
First, among asexually reproducing species, what main mechanism produces genetic changes from one generation to the next, and how does this mechanism do so? Next, describe in detail three main mechanisms that produce genetic diversity among sexually reproducing species, placing emphasis on how two mechanisms in meiosis do so. Lastly, most eukaryotic organisms reproduce sexually. What is a survival benefit(s) of this mode of reproduction?
Copy your prepared response in the text box provided. Your answer should be around 400 words or 1-2 well-developed paragraphs.
In: Biology
CORPORATE SOCIAL RESPONSIBILITY
Think about how your company's social responsibility has changed
your purchasing decision. What changes will you have in the future
as a result of your learning? Consider your last three largest
purchases. (EX: Men's products, household appliances, foodstuffs,
etc.) Go to the website of the company that manufactures the
purchased product and explore the company's commitment to social
responsibility. Are they more or less than they expected? Does your
discovery make a difference to you about your purchases and / or
how you think about the money you spent on these items?
In: Operations Management
Aarong Dairy’s use of different organizational structural forms to pursue its strategic goals is described in this case. Emphasis is placed on Aarong’s business model and how its structural forms play a key role in the business model.
Although Aarong Dairy neither owns cows nor an actual farm, it has successfully organized thousands of micro-scale dairy farmers to serve as a reliable supplier base for its milk needs. The key lesson of this case is about the significance of boundary-less structures to pursue certain firm strategies.
Read the case below and answer the questions that follow.
Founded in 1998, Bangladesh’s Aarong Dairy is a social enterprise that has employed boundary-less structural forms to implement its strategies of meeting consumer dairy needs and providing a selling platform for micro-scale milk producers.
In Bangladesh, the micro-scale dairy farmers had historically struggled to receive fair prices for the milk they produced. These farmers had cows that produced low quantities of milk. No systematic approach to administering and managing cow-feed existed. Notwithstanding the involvement of plenty of locals in the milk trade, there had been no permanent market. Rahman (2015) narrates that “at times … there was hardly any demand or the demand was too erratic to be profitable for them. Low quantities of milk produced by their cows also meant that milk production was an expensive process. Poor breeding, limited veterinary services and shortages in cow feed were some of the other challenges faced by dairy farmers.”
Aarong Dairy was founded in 1998 with an aim to provide a permanent market place for the thousands of micro-scale dairy farmers. As a result, Aarong Dairy is a dairy farm that neither owns cows, nor engages in actual milk production. For a dairy farm that does not own any cows and does not directly engage in milk production, “Aarong Dairy collects 102,559 liters milk daily and serves 50,000 farmers, 64 percent being women” (Rahman, 2015).
From Aarong Dairy the micro-scale dairy farmers receives training in para-veterinary services, cattle feed administration, and artificial insemination for improved breeds of cows that produce more milk. To provide access to a permanent and reliable market, Aarong Dairy bought the milk that the farmers produced. This arrangement allowed the micro-scale dairy farmers to have guaranteed payments based on their individual level and quality of milk production. The advantage for Aarong Dairy is that thousands of micro-scale dairy farmers serve as its dedicated milk production units, yet Aarong Dairy does not have to be responsible for the operations and overhead of these micro-scale dairy farmers. The permeable structure allows Aarong Dairy to operate as if it were fully vertically integrated.
At times, Aarong Dairy has extended loans to micro-scale dairy farmers to expand their milk production scale. Those are akin to contractually agreed upon partnerships between two businesses. Here, Aarong’s financial support helps the micro-scale farmer to expand the production scale and become a more reliable milk supplier for Aarong Dairy. Each of these partnerships are governed by a different kind of permeable structure where formal contracts help the parties involved to bridge some of the typical barriers to help each other for the greater collective good.
Aarong Dairy adds value to the milk production process precisely in areas where micro-scale dairy farmers are unable to do so. Aarong Dairy plays essential roles in milk preservation, pasteurization, quality control, logistics, and marketing. The micro-scale dairy farmers are not capable of fulfilling this requirement, and thus Aarong Dairy serves as the permanent market place for these thousands of micro-scale dairy farmers. According to Rahman (2015), “Aarong Dairy thus removed the major headaches for the farmers such as where to store to the milk and how to transport the milk. Aarong Dairy has gone on to set up 101 chilling plants….”
1. According to the story, for a dairy farm that neither owns any cows nor directly engages in milk production, how much milk does Aarong Dairy collect every day?
Multiple Choice
Between 100,000 and 105,000 liters
Between 95,000 and 100,000 liters
Between 105,000 and 110,000 liters
Between 110,000 and 115,000 liters
2. To ensure smooth functioning of its supply chain, Aarong has most likely utilized which form of boundaryless structure to organize the 50,000 dairy farmers?
Multiple Choice
Vertical Integration
Virtual
Modular
Barrier-free
3. Aarong Dairy extends loans to micro-scale dairy farmers to expand their milk production scale. Aarong’s financial support helps the micro-scale farmer to expand the production scale and become a more reliable milk supplier for Aarong Dairy. What kind of permeable structure is most likely used to manage these partnerships?
Multiple Choice
Vertical Integration
Barrier-free
Modular
Virtual
4. Which of the following is NOT one of the ways that Aarong Dairy adds value?
Multiple Choice
Logistics and marketing
Milk preservation
Milk production
Milk pasteurization
In: Operations Management
Lakeridge Home has four scheduled support workers assigned to the A wing in which you are working. You are assigned to a client who is combative and a fall risk. One of your co-workers walks past your combative client’s room and sees the client trying to get out of bed. The client falls and sustain a head injury. What should your co-worker had done first, and why? What safety concerns must be monitored and what changes need to make on the patient care plan? How could the co-worker display teamwork in this situation?
In: Nursing