A business user is analyzing most travelled flight routes in Mid-west area. He is coming up with the count of passengers who flew from one city to another city and total amount (as part of revenue). There are about 120 routes that he is analyzing. He is analyzing flight data month wise for past 6 years. Assuming that the above requirements are complete and will be used for creating a report, identify all the Dimensions and Facts. (Hint: There is 2 fact.)
Q: Auga Company Ltd Comparative Balance Sheet December 31, 2021 and 2020 2021…
A: Statement of Cash Flow - Statement of Cash Flow shows the increase and decrease in cash for the…
Q: Scenario: The 2021 comparative balance sheet and income statement of Auga Company Ltd, have…
A: Statement of Cash Flows - Statement of Cash Flows show the movement of cash in the financial year.…
Q: Presented here is the income statement for Fairchild Co. for March: Sales $ 81,500 Cost…
A: A contribution margin income statement subtracts all variable expenses from sales to calculate the…
Q: Q1 (a) Imagine a signalling model where there are two types of workers, low productivity workers…
A: Introduction:- The term "equilibrium" refers to a scenario in which market supply and demand are…
Q: This question is based on t he following information: B Hon Company purchases thermostats and use…
A: Note: The 2nd question doesn't seems to be part of the database mentioned above. I request you to…
Q: Advantages of Social media and its effect on individual life as well as businesses
A: Advantage of social media and its effect on individual life as well as business
Q: For its first year of operations, Tringali Corporation's reconciliation of pretax accounting income…
A: Solution: Taxable income = $265,000 Taxable temporary differences = $20,000 Tax rate = 25%
Q: Let us assume that the Adjusted Trial Balance of Masagana Tailoring Shop as of December31,2018 is as…
A: Financial Statement - Financial Statements are the statement includes income statement, Equity…
Q: The following transactions and adjusting entries were completed by a local delivery company called…
A: The question is related to the Journal Entries for the transactions made during the year 2020 and…
Q: Parker Plastic, Inc., manufactures plastic mats to use with rolling office chairs. Its standard cost…
A: Direct material price variance = (Actual quantity ×Standard price)-(Actual quantity ×Actual price)
Q: Bree and Kyle are not related. During 2020, Bree loans Kyle $15,000, which he intends to use to…
A: Loan receivables from Kyle = $15,000 For the year 2021: It is estimated that the creditors will…
Q: A worker is paid $10,000 per month and a dearness allowance of $2,000 p.m. Worker Contribution to…
A: Basic salary includes wages and dearness allowance. Contribution to provident fund is calculated on…
Q: What ROI will equate the PV of Inflows and the PV of outflows? a. Internal rate of return (IRR) b.…
A: Option b is incorrect because cost of capital means the cost that is incurred by the organization on…
Q: 2. Gold Co. had 200,000 shares of common stock, 40,000 shares of convertible preferred stock, and…
A: Solution:- Given, Gold Co. had 200,000 shares of common stock 40,000 shares of convertible preferred…
Q: The 2021 comparative balance sheet and income statement of Auga Company Ltd, have just been…
A: A cash flow statement is a statement that shows the cash inflow or outflow under three activities…
Q: Krostel Company is planning to acquire a machine costing P 500,000 with a useful life of 3 years…
A: Accounting rate of return = Average Annual Income/ Average Investment Accounting rate of return = P…
Q: Q1) Pier 1 Imports operates almost 1,000 stores around the world. Assume you are dealing with a Pier…
A: The perpetual inventory system records the cost of goods sold and sales with every transaction made…
Q: Partially completed budget performance reports for Delmar Company, a manufacturer of light duty…
A: The input of resources as well as the production of services for each unit within an organisation…
Q: Tarkington Freight Service provides delivery of merchandise to retail grocery stores in the…
A: Financial statements are those statements which shows the financial position and the performance of…
Q: There are a number of benefits associated with budgeting. Which of the following is not frequently…
A: Budgeting refers to the process of estimation of revenues and expenses for an entity over a specific…
Q: Auga Company Ltd Comparative Balance Sheet December 31, 2021 and 2020 2021 2020…
A: Cash flow statement The purpose of preparing the cash flow statement is to know the movement of the…
Q: olve q
A: In an accrual basis income is recorded when it is earned or accrued and In the cash basis system,…
Q: Requirement: Calculate the investment centers': 1) Sales Margin 2) Capital Turnover 3) Return on…
A: Answer:
Q: A company invests in a fitness facility for its employees that costs $2,000,00 company saves…
A: Discounted Payback Period A capital budgeting tool for determining a project's profitability is the…
Q: Baird Medical Clinic has budgeted the following cash flows. February $108,000 March January $102,000…
A: Cash budget is prepared when one wants to asses whether there is sufficient amount of cash in hand…
Q: Auga Company Ltd Comparative Balance Sheet December 31, 2021 and 2020 2021 2020…
A: The question is related to Cash Flow Statement. Cash Flow Statement is summary of cash receipts and…
Q: Project A and project B have the same salvage value. The life of project A is 10 years while the…
A: Present Value of the Salvage Value will be higher for the Project which have the smaller life…
Q: PA9.) Use the following excerpts from Yardley Company's financial information to prepare a statement…
A: The cash flow statement is part of the financial statements of the company. It is prepared at the…
Q: Wooden Grain Co. has organized a new division to manufacture and sell specially designed tables for…
A: In this question, there are 3 requirements: Unit inventorial costs under absorption costing and…
Q: Answer the following questions for the directors: True or false, does the statement of cash flows…
A: Statement of Cash Flows is a Financial Statement which provides data about the movement of cash of a…
Q: Explain the concept of relevant range and
A: Fixed costs refer to the expenses that do not increase or decline with changes in the company's…
Q: D&R Corp. has annual revenues of $262,000, an average contribution margin ratio of 33%, and fixed…
A: Average contribution margin = 33% Variable cost per unit = $8.7 Therefore, the selling price should…
Q: A borrower and lender agree on a negative-amortizing loan in the amount of $300,000 at 4% interest…
A: Negative amortization Loan amount = $ 300000 Rate of Interest = 4% Amount Due at the Maturity =…
Q: What should be in the credit file
A: Following is the contains in credit file
Q: discuss FASB standard in working capital
A: The Financial Accounting Standards Board (FASB) is a private standard-setting body whose primary…
Q: 1. How much is the gross profit? 2. How much is the administrative expense?
A: Sales 15500000 Cost of Goods Sold 6500000 Legal and Audit Fees 700000 Rent for Office…
Q: Below are departmental income statements for a guitar manufacturer. The company classifies…
A: Direct expenses are those which are associated to the goods directly. This simply means that the…
Q: . Under the current allocation system, what is the cost that will be allocated from Accounts…
A: Solution:- a)Determination of costs to be allocated to Personal and Business divisions based on the…
Q: D. True or false, the financing activities section of the statement of cash flows reflects the cash…
A: Statement of Cash Flows explains the differences between the net income and cash and cash equivalent…
Q: On January 1, 2021, Ganda Company issued P5,000,000, 8% serial bonds payable to be repaid in the…
A: Interest expense on December 31, 2021 = present value of the bonds x yield rate x no. of the months…
Q: A company incurred $200,000 of manufacturing cost during the month, with a beginning finished goods…
A: Formula: Cost of goods sold = Beginning finished goods + Manufacturing costs - Ending finished goods
Q: During 2020, Brandi loans her brother Keefer $40,000, which he intends to use to establish a small…
A: A bad debt deduction is allowed for that amount of bad debt which has become irrecoverable in the…
Q: Which one of the following is a correct statement about the nontax characteristics of a pooled…
A: B)The principal is distributed to the charitable beneficiary at the end of the noncharitable…
Q: Purchase related transactions the following selected transactions were completed by epic co-during
A: For August 3 : Inventory = 33400 * 98% = 32732 For August 13 : Cash = 32732 - 2450 = 30282
Q: The following data relate to product PQ Selling price $215 per unit…
A: Solution .. Selling price per unit = $215 Variable cost per unit = $120 Contribution margin per…
Q: The following data have been provided by Your Corporation: Standard MH per motor 8.6 MH Standard $…
A: The spending variance is the difference between the actual data and flexible budget of the…
Q: Which of the following is used when computing for the accounting rate of return (ARR)? a. Income…
A: The accounting rate of return is the average net income an asset is expected to generate on the…
Q: Delta Air Lines, Inc. (DAL) provides cargo and passenger services throughout the world. The…
A: Common sized Income Statements An income statement with a common size is one in which each line…
Q: Harold Fishing Gear Company's acquired Sea Breeze Ltd for $450,000. The book values and fair values…
A: Solution: Purchase price of Sea Breeze Ltd = $450,000 Fair value of net assets of Sea Breeze = Fair…
Q: Problem 7-5 Carr Company reported the following shareholders' equity on January 1, 2019. Preference…
A: Solution Notes- 1- Share premium = (90000+3500000) = 3590000. 2- Retirement of treasury shares:…
- A business user is analyzing most travelled flight routes in Mid-west area. He is coming up with the count of passengers who flew from one city to another city and total amount (as part of revenue). There are about 120 routes that he is analyzing. He is analyzing flight data month wise for past 6 years.
Assuming that the above requirements are complete and will be used for creating a report, identify all the Dimensions and Facts. (Hint: There is 2 fact.)
Step by step
Solved in 2 steps
- Westover Travel offers travel packages using both air and ocean travel. Westover offers two packages, Tourist and Premier, that differ in the accommodations, class of travel, and so on. Westover has a call center, which handles customer queries and complaints. The call center tracks the number of calls and the number of call-minutes for customers by the package they have purchased. Expected call center data for next month follow. Call center volume: Number of calls Number of call minutes Call center costs: Call-related Call minute-related Total call center costs Tourist 29,000 126,000 Required: Total $ 222,950 106,920 $ 329,870 The call center at Westover uses a two-stage cost allocation system: It uses the number of calls to allocate call-related costs and the number of call minutes to allocate call minute-related costs. Premier 16,500 198,000 a. Call related-overhead rate b. Call minute-related overhead rate c. Call center costs allocated to Tourist d. Call center costs allocated to…When a company has post-acquisition expenditures related to Property, Plant, and Equipment it must determine whether the amount should be expensed as an ordinary repair or capitalized as a major repair, addition, or betterment. This requires considering the nature of the expenditure and the use of judgment. Many companies use a threshold amount. Any expenditure below the threshold is expensed. Items over the threshold are examined and a decision is made about whether to expense or capitalize the item. This approach is justified by both materiality and considering costs and benefits. For example, a company with $94 million in net property, plant, and equipment and $250 million of operating expenses would not consider a $100 repair as material. Plus, if the company had to spend thousands of dollars examining every repair expenditure, the costs of doing the analysis could easily outweigh the benefits. SouthEast Equipment has a large number of machines and equipment that are available for…For the past few years, your client, Omni Care, has operated a small medical practice. Omni Care's current annual revenues are $945,000. Because the accountant has been spending more time each month recording all transactions in a two-column journal and preparing the financial statements, Omni Care is considering improving the accounting system by adding special journals and subsidiary ledgers. Omni Care has asked you to help with this project and has compiled the following information: Estimated Frequency per Month Type of Transaction Fees earned on account 240 Purchase of medical supplies on account 190 Cash receipts from patients on account 175 Cash payments on account 160 Cash receipts from patients at time services are provided Purchase of office supplies on account 120 35 Purchase of magazine subscriptions on account Purchase of medical equipment on account 4 Cash payments for office salaries 3 Cash payments for utilities expense Briefly discuss the circumstances under which…
- Solar Solutions began operations on January 1, 2015, and is now in its sixth year of operations. It is a retail sales company with a large amount of online sales. The adjusted trial balance as of December 31, 2020 appears below, along with prior year balance sheet data and some additional transaction data for 2020. SOLAR SOLUTIONS Adjusted Trial Balance 12/31/2020 2020 2019 Account Title Adjusted Trial Balance Post-Closing Trial Balance Debit Credit Debit Credit Cash $ 122,200 55,000 125,600 Accounts Receivable 35,000 Prepaid Insurance 5,000 6,000 |Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Salaries Payable Sales Tax Payable Note Payable-Long Term Common Stock, $10 par 46,000 15,600 63,000 47,000 59,000 21,000 21,000 16,000 11,200 16,800 2,600 2,700 2,000 4,000 31,000 22,100 240,000 160,000 Retained Earnings 28,600 28,600 Dividends 10,000 Sales Revenue Cost of Goods Sold Rent Expense Salaries Expense 235,000 127,600 20,000 36,000 Insurance…You are analysing the performance of the 5 top planning consultants in your company. You are interested in the revenue generated from projects completed in the second half of the year. please RANK the consultants from MOST revenue generated to LEAST revenue generated between July and December (Q3 and Q4).You are a financial accountant for a small business and have been tasked with preparing a monograph for the company's financial statements. The monograph should include a list of economic events that have occurred over the course of one month, including: 1) receivables, 2)merchandising assets, 3)sales, 4)VAT, 5) prepaid expenses and revenues (these five categories have to be in your monograph as mandatory). Your list should include 15 economic events. For each economic event, you will need to create a general journal entry, post the entry to the general ledger, prepare a trial balance, and ultimately prepare the company's income statement and balance sheet. To complete this assignment, you will need to: 1. Create a list of at least 15 economic events that have occurred over the course of one month. Make sure to include the mandatory economic events mentioned above and any other important events that you can think of. 2. For each economic event, create a general journal entry and post…
- A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last semester are provided in the tile MktHrsPts. Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between total points earned and hours spent studying? Develop an estimated regression equation showing how total points earned is related to hours spent studying. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.01 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? How much of the variation in the sample values of total point earned does the model you estimated in part (b) explain? Mark Sweeney spent 95 hours studying. Use the regression model you estimated in part (b) to predict the total points Mark earned.Be creative. You are a financial accountant for a small business and have been tasked with preparing a monograph for the company's financial statements. The monograph should include a list of economic events that have occurred over the course of one month, including: 1) receivables, 2) merchandising assets, 3) sales, 4) VAT, 5) prepaid expenses and revenues (these five categories have to be in your monograph as mandatory). Your list should include 15 economic events. For each economic event, you will need to create a general journal entry, post the entry to the general ledger, prepare a trial balance, and ultimately prepare the company's income statement and balance sheet. To complete this assignment, you will need to: 1. Create a list of at least 15 economic events that have occurred over the course of one month. Make sure to include the mandatory economic events mentioned above and any other important events that you can think of. 2. For each economic event, create a general journal…The problem says: jakes cabins is a small hotel chain with locations near the national parks of Utah Wyoming Montana. The chain has a total of 500 guestrooms. The following operating data are available for June. See the attached photo. I need to figure out how I determine the available room nights for June and how I determine the occupancy rate for June.
- In March 2024, Price Company began developing a new software system to be used internally for managing its inventory. The software integrates customer orders with inventory on hand to automatically place orders for additional inventory when needed. The software then automatically records inventory as the shipment is received and read by scanners. The software development was completed in October 2024 at a cost of $150,000. Of this amount, $25,000 was spent before the application development stage was established. Price expects to use the software for at least five years. Determine the initial amount that Price should capitalize as software development costs. Capitalized costsThe Northwest regional manager of Logan Outdoor Equipment Company has conducted a study to determine how her store managers are allocating their time. A study was undertaken over three weeks that collected the following data related to the percentage of time each store manager spent on the tasks of attending required meetings, preparing business reports, customer interaction, and being idle. The results of the data collection appear in the following table: a. Create a stacked-bar chart with locations along the vertical axis. Reformat the bar chart to best display these data by adding axis labels, a chart title, and so on. b. Create a clustered-bar chart with locations along the vertical axis and clusters of tasks. Reformat the bar chart to best display these data by adding axis labels, a chart title, and the like. c. Create multiple bar charts in which each location becomes a single bar chart showing the percentage of time spent on tasks. Reformat the bar charts to best display these data by adding axis labels, a chart title, and so forth. d. Which form of bar chart (stacked, clustered, or multiple) is preferable for these data? Why? e. What can we infer about the differences among how store managers are allocating their time at the different locations?Before you begin this assignment, review the Tying It All Together feature in the chapter. Part of Fry’s Electronics, Inc.'s experience involves providing technical support to its customers. This includes in-home installations of electronics and also computer support at their retail store locations. Requirements Suppose Fry’s Electronics, Inc. provides $10,500 of computer support at the Dallas-Fort Worth store during the month of November. How would Fry's Electronics record this transaction? Assume all customers paid in cash. What financial statement(s) would this transaction affect? Assume Fry’s Electronics, Inc.’s Modesto, California, location received $24,000 for an annual contract to provide computer support to the local city government. How would Fry’s Electronics record this transaction? What financial statement(s) would this transaction affect? What is the difference in how revenue is recorded in requirements 1 and 2? Clearly state when revenue is recorded in each requirement.