i have strugling with this question doing on excel. could you please help me to find out it <\/p>
Details of Keira Pty Ltd's income statement for the past year are as follows:<\/p>
Sales (18 000 units) Cost of sales:<\/p>
Direct materials<\/p>
Direct labour<\/p>
Variable factory overhead<\/p>
Fixed factory overhead<\/p>
GROSS PROFIT<\/p>
Variable selling expenses<\/p>
Fixed selling and admin expenses PROFIT BEFORE TAX<\/p>
Income tax expense (30%) PROFIT<\/p>
$290,000 310,000 102,000<\/p>
42,000<\/p>
96,000 30,000<\/p>
$990,000<\/p>
744,000 246,000<\/p>
126,000 120,000 36,000 84,000<\/p>
Required:<\/p>
Consider each of the following independent situations:<\/p>
<\/p>", "transcribed_text": "", "related_book": { "title": "Income Tax Fundamentals 2013", "isbn": "1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516", "edition": "31st Edition", "authors": "Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/1124.jpg", "uri": "\/textbooks\/income-tax-fundamentals-2013-31st-edition-9781285586618", "see_more_uri": "" }, "free_related_book": { "isbn": "0692651640", "uri": "\/textbooks\/death-an-exploration-learning-to-embrace-lifes-most-feared-mystery-1st-edition-978-0692651643-262457", "name": "Death An Exploration Learning To Embrace Lifes Most Feared Mystery", "edition": "1st Edition" }, "question_posted": "2024-06-28 04:35:11", "see_more_questions_link": "\/study-help\/questions\/business-marketing-2022-June-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/what-substantive-tests-of-transactions-are-typically-performed-for-this", "description": "What substantive tests of transactions are typically performed for this process?", "stars": 3 }, { "url": "\/study-help\/psychology\/1-establish-a-place-for-listing-assignments-some-teachers-reserve-1984107", "description": "1. Establish a place for listing assignments. Some teachers reserve a particular corner of the board for assignments. Others write assignments in colored chalk. For younger students, it may be better...", "stars": 3 }, { "url": "\/in-2010-elbert-corporation-had-net-cash-provided-by-operating", "description": "In 2010, Elbert Corporation had net cash provided by operating activities of $531,000; net cash used by investing activities of $963,000; and net cash provided by financing activities of $585,000. At...", "stars": 3 }, { "url": "\/study-help\/questions\/a-database-should-be-structured-in-order-to-select-one-9846269", "description": "A database should be structured in order to: Select one: a. ease and speed up add and retrieval O b. ease and speed up search and retrieval O c. ease and speed up delete and retrieval O d. ease and...", "stars": 3 }, { "url": "\/study-help\/questions\/conn-mans-shops-a-national-clothing-chain-had-sales-of-5605840", "description": "Conn Man's Shops, a national clothing chain, had sales of $420 million last year. The business has a steady net profit margin of 8 percent and a dividend payout ratio of 25 percent. The balance sheet...", "stars": 3 }, { "url": "\/study-help\/questions\/olney-llc-only-purchased-one-asset-this-year-olney-llc-3491911", "description": "Olney LLC only purchased one asset this year. Olney LLC placed in service on July 19, 2023, machinery and equipment (seven-year property) with a basis of $1,330,000. Assume that Olney has sufficient...", "stars": 3 }, { "url": "\/study-help\/questions\/a-marketing-company-needs-to-decide-how-much-time-to-1004091", "description": "A marketing company needs to decide how much time to allocate between radio and television advertising during the next month. The manager has determined that at least 80% of the time should be...", "stars": 3 }, { "url": "\/study-help\/questions\/melany-is-a-behavior-technician-that-is-teaching-their-client-3510674", "description": "Melany is a behavior technician that is teaching their client how to identify various household items. If the supervising Board Certified Behavior Analyst (BCBA) wants to measure that the program is...", "stars": 3 }, { "url": "\/study-help\/questions\/economic-research-has-identified-a-trend-exhibited-by-one-in-5060076", "description": "Economic research has identified a trend exhibited by one in six Britons of hiding cash in their homes instead of investing it. This is termed the \"Biscuit Tin Economy.\" It is estimated that $3.5...", "stars": 3 }, { "url": "\/study-help\/questions\/how-does-purchasing-bring-value-to-a-organization-when-thinking-1004281", "description": "How does Purchasing bring value to a organization? When thinking about the sort ( reject nothing to need), set in order ( tidy up), shine ( keep workplace up ) , standardize ( make neatness a rule),...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/upload-load-a-file-or-choose-a-file-youve-already-4238839", "next": "\/study-help\/questions\/sidneys-building-which-is-used-in-his-trade-or-business-4238841" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "i have strugling with this question doing on excel. could you please", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/i-have-strugling-with-this-question-doing-on-excel-could-4238840" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } }} }