Bright Academic Experts

Category: Accounting

  • managerial accounting assignement

    Outside Environment, Inc. provides commercial landscaping services in San Diego. Sasha Cairns, thefirm’s owner, wants to develop cost estimates that she can use to prepare bids on jobs. After analyzingthe firm’s costs, Cairns has developed the following preliminary cost estimates for each 1,000 squarefeet of landscaping.Cairns is quite certain about the estimates for direct material and direct labor. However, she is not ascomfortable with the overhead estimate. The estimate for overhead is based on the overhead costs thatwere incurred during the past 12 months as presented in the following schedule. The estimate of $18per direct-labor hour was determined by dividing the total overhead costs for the 12-month period($1,296,000) by the total direct-labor hours (72,000).Cairns believes that overhead is affected by total monthly direct-labor hours. Cairns decided to performa least-squares regression of overhead (OH) on total direct-labor hours (DLH).Required:1. Develop cost formula for overhead cost using least square regression method by constructingexcel spreadsheet.2. The overhead rate developed from the least-squares regression is different from Cairns’preliminary estimate of $18 per direct-labor hour. Explain the difference in the two overheadrates.3. Using the overhead formula that was derived from the least-squares regression, determine atotal variable-cost estimate for each 1,000 square feet of landscaping.4. Cairns has been asked to submit a bid on a landscaping project for the city governmentconsisting of 50,000 square feet. Cairns estimates that 30 percent of the direct-labor hoursrequired for the project will be on overtime. Calculate the incremental costs that should be included in any bid that Cairns would submit on this project. Use the overhead formula derivedfrom the least-squares regression.5. Should management rely on the overhead formula derived from the least-squares regression asthe basis for the variable overhead component of its cost estimate? Explain your answer.

    Requirements:

  • Introduction to Accounting and Its Importance in Business

    Accounting is the process of recording, summarizing, analyzing, and reporting financial transactions of a business. It helps businesses track income, expenses, assets, and liabilities. Accounting is important because it shows whether a business is making profit or loss and helps owners make informed decisions. It also helps in budgeting, planning, and paying taxes correctly.

    There are different types of accounting such as financial accounting, management accounting, and cost accounting. Financial accounting focuses on preparing financial statements like the income statement and balance sheet. Management accounting helps managers make internal business decisions.

    Accounting ensures transparency, accountability, and proper financial management in any organization.

    Requirements:

  • Accounting Disscusion HW

    Dicks Sporting Goods, Inc. (NYSE: DKS) is headquartered in Pennsylvania and is a leading sporting goods retailer. Dicks Sporting Goods, Inc. offers a variety of high-quality sports equipment, apparel, footwear, and accessories. The company sells inventory in its stores (Dicks Sporting Goods, Golf Galaxy, Field & Stream, Public Lands, and Going Going Gone!) and online through its Web site. Visit

    Requirements

    1. On which financial statement would you find Merchandise Inventory? What was the amount of merchandise inventory as of January 29, 2022, and January 30, 2021?
    2. On which financial statement would you find Cost of Goods Sold? What does Cost of Goods Sold represent? What was the amount of cost of goods sold for fiscal year ended January 29, 2022, and fiscal year ended January 30, 2021?
    3. How could you determine the amount of profit that Dicks Sporting Goods, Inc. earns when selling its merchandise inventory? What is this amount for the fiscal year ending January 29, 2022? Provide the calculation for gross profit.

  • Accounting: hotels data in Turkey

    hi,

    I have the attached data, but I cant find any source for it.

    My request is, change the hotels and write their data and mention the sources.

    Or try to find sources mentioned the data already written in the file.

    hotels must be only in Turkey

    Requirements: -0

  • Accounting technology application learning objective 1

    ACCT 300 Project 1- Using MS Access to create database and query information

    It is necessary for accounting students to understand stock prices and their trending patterns. The intelligence about the stock market is not easy; many professionals dedicate their spend whole career lives on this understanding. According to behavior economics, animal spirit, fear, and euphoria can significantly impact stock. This assignment aims to train your understanding by practicing database skills with a fear and greed index and stock price datasets. In this project, you are required to complete two tasks: (1) create a database (SentimentImpactStockPrice) with two linked tables with two spreadsheet datasets and (2) develop four queries from the developed database. You need to upload the databases with these four queries to your Canvas assignment account. Please name your first database as “FirstNameLastName_SentimentImpactStockPrice” (e.g., JiahuaZhou_SentimentImpactStockPrice.accdb.

    Task 1: Please follow the guidance below to (1) download two datasets, (2) feed the two spreadsheet datasets into MS ACCESS as two tables, and (3) integrate the two tables with the link of primary and foreign keys (Hint: MS ACCESS is more friendly with Excel Workbook, your downloaded file may be .csv, or other file forms. It is better to transform Excel Workbook. You can just click the file save as, and change the file type as Excel Workbook).

    The first dataset specifically includes daily closing prices of Bitcoin, as well as daily volumes of Bitcoin, and the Fear and Greed Index values for the overall crypto market (I downloaded the in the canvas for you. You also can download it from ). This dataset presents a unique opportunity for researchers and analysts to explore the relationship between the prices and volumes of Bitcoin, as well as the sentiment of the overall crypto market. By conducting thorough analysis of this dataset, researchers and analysts can gain valuable insights into the behavior and trends of the cryptocurrency market. This includes examining the daily closing prices and volumes of Bitcoin, as well as the Fear and Greed Index values for the overall crypto market (this index is a composed indicator that includes various measurements, ). Through comprehensive analysis, potential patterns, trends, and correlations between price movements, trading volumes, and market sentiment can be identified. These insights can inform investment strategies and decision-making, providing a more nuanced understanding of the dynamics of the cryptocurrency market. This data presents a unique opportunity for researchers and analysts to uncover valuable information that can contribute to a deeper understanding of the cryptocurrency market and its potential implications for investment decision-making.

    Please download a stock price dataset (You can choose one of the following stocks: Tesla, Google, JPMorgan Chase, GE) from .

    You can name the first Table, tblGreedFearIndex (we usually name tables and attributes as several words without spaces between them), and the second table, tblStockPrice. You need to integrate these two tables with the link of primary key and foreign key.

    Hint: The objective of this database is to observe the relationship between the greed index and stock price. We need to observe the movement of the index and stock price on the same date. Thus, date can be a unique attribute and act as the primary key in two tables. We can integrate these two tables by using Date. To simplify the demonstration, the following video only uses Google’s stock price and the Greed Index data as examples.

    Course video:

    Task 2: Develop the following with the database developed from Task 1. Before you start these queries, please understand the database’s data dictionary and tables’ relationship by clicking the Relationships” under the “Database Tools” button. With this information, you can know which tables you need for the following queries and select the necessary tables for your queries.

    Query 1 (name it as qryExtremeFear): Please report Date, Value, BTC_Volume, Close, and Volume when the Value_Class (fear index) is Extreme Fear

    Query 2 (name it as qry2020StockPerformance): Please report Date, Open, High, Low, Close from January 1, 2020, to December 31, 2020.

    Query 3 (name it as qryHighVolatileStock): Please report Value, Value_Class when High >=1.5*Low and Close > Open.

    Query 4 (name it as qryExtremeFearDays): Please list Close, Volume, BTC_Volume if Vlaue is smaller than 25 from March 2021 to September 2021, and also report how many days the Value_Class is Extreme Fear.

    Note: You may use Count () function in this query. The count function is usually used in conjunction with the Group By clause to return the number of records of a data field.

  • Mcgaw Hill Connect Homework Problems

    Class 20 and Class 16 Homework Problems. The tutor will need to log in to McGraw-Hill Connect Homework Problems to see.

  • Mcgraw Hill Connect Assignments

    Working on McGraw-Hill Connect Assignments. Need it done in 12 hours

  • Mcgraw Hill Connect Assignments

    McGraw-Hill Connect Assignments. Class 20 and Class 16 homework assignments

  • Discussion post

    I need a discussion post answering all questions in order. Please provide sources and in text citation.

  • Chapter 4 homework

    Use Excel.

    1 Create an adjusted trial balance. (hint use very few accounts 3 asset, 2 liability, 3 stockholder’s equity, 1 revenue, 2 expense) Do not do the worksheet that is in problem 1 (a). You must have the contra accounts dividends and accumulated depreciation-eq. Make up the numbers. It must balance.

    2. Create an income statement, retained earnings statement and classified balance sheet. Use 1-21 in the e-book as a guide or look at the homework you manually did from chapter 2.

    3. Journalized the closing entries. Zero out the income statement accounts (Revenue & Expenses) to income summary, then zero out income summary to retained earnings. Zero out dividends to retained earnings. (You have just increased the equity of the company by the net income, minus what was given to the owners.)

    4. Assume you posted the closing journal entires to the ledger and zeroed out the revenue, expense and dividend accounts. Create a post closing trial balance.