What are the values for sales that were calculated for the following inventory items? What is the value of total sales from the query? Which month had the highest sum of sales? What specifically was the sales amount?

/in /by

Homework: Data Analysis

Required information [The following information applies to the questions displayed below]

Use the Access Practice.accdb database to complete the following tasks in Access. Microsoft Access is required for this problem.

Use the database to complete tasks a through g in Access. Answer the questions below after completing tasks d, e, and g, respectively.

  • a. The database contains three tables containing information about this company’s sales process: Inventory, Sales, and Salesltems. Use the Relationships window to link the tables together.
  • b. The Salesltems table records the quantity and price of each item sold on each sale (sales may include more than one item). Calculate the extended amount of sale (call it Amt) for each item (Quantity * UnitPrice). Include InvoicelD, InventorylD, Quantity, and UnitPrice in the query. Name the query Item_Extension_Calculation.
  • c. Calculate the total dollar amount of each sale. Include InvoicelD, InvoiceDate, CustomerlD, and EmployeelD from the Sales table and the Amt from the Item_Extension_Calculation query. Name the query Sale_Amount_Calculation.
  • d. Calculate total sales for each inventory item.
  • e. Calculate total sales.
  • f. Calculate the month in which each sale occurred. Include InvoicelD and InvoiceDate from the Sales table. Name the query Sales_Months. (Hint Look for the Month function in the expression builder.)
  • g. Calculate the sum of sales for each month.

Required:

  1. What are the values for sales that were calculated for the following inventory items?
  2. What is the value of total sales from the query?
  3. Which month had the highest sum of sales? What specifically was the sales amount?

Identify and describe Reed’s responsibilities to detect Smith’s errors and fraud. Describe Reed’s responsibilities to detect Smith’s material noncompliance with laws.

/in /by

Discussion post_Audit accounting

Study Cases

1. Questions requiring analysis – read question below and answer in your own words
Reed, CPA, accepted an engagement to audit the financial statements of Smith Company.
Reed’s discussions with Smith’s new management and the predecessor auditor indicated the possibility that Smith’s financial statements may be misstated due to the possible occurrence of errors, fraud, and illegal acts.

a. Identify and describe Reed’s responsibilities to detect Smith’s errors and fraud. Do not identify specific audit procedures.
b. Describe Reed’s responsibilities to detect Smith’s material noncompliance with laws. Do not identify specific audit procedures.
c. Identify and describe Reed’s responsibilities to report Smith’s noncompliance with laws

2. Questions requiring analysis – read question below and answer in your own words.

Tracy Smith, CPA, is in charge of the audit of Olympic Fashions, Inc. Seven young members of the public accounting firm’s professional staff are working with Smith on this engagement, and several of the young auditors are avid skiers. Olympic Fashions owns two condominiums in Aspen, Colorado, that it uses primarily to entertain clients. The controller of Olympic Fashions has told Smith that she and any of her audit staff are welcome to use the condominiums at no charge any time that they are not already in use. How should Smith respond to this offer? Explain.

Assignments:
1. Provide the answers to 2 questions above with a minimum of 100 words per 2. Provide the meaningful response to 3 students’ posts below with a minimum of 100 words per response.

Determine the capital structure of the firm: Determine the market value of the firm’s debt and equity. Explain the approach and procedure you used and use these values to determine the weights for the WACC.

/in /by

Firm Financial Analysis Project Segment 3 Parts 5 Macy’s Inc

For the third segment of the Firm’s Financial Analysis Project, use the company that you selected in Segment MACY’S 1 to determine the Weighted Average Cost of Capital. Using the principles and tools outlined in the textbook, form an estimate of the WACC for the firm. In order to complete this task, you will need to do the following:

  • Determine the cost of debt: Using information from the firm’s website, annual report, and the Stafford Library’s database sources, determine the ‘average’ rating of your firm’s bonds and the current YTM on a composite of these bonds. Based on this information, estimate the current cost of debt for the firm. Explain the approach and procedure you used to make your determination and what this number means.
  • Determine the cost of equity: Determine the required rate of return for your firm using the CAPM. Explain the approach and procedure you used (and justification for the sources of inputs used for your model) to make your determination and the meaning of this required rate of return.
  • Determine the capital structure of the firm: Determine the market value of the firm’s debt and equity. Explain the approach and procedure you used and use these values to determine the weights for the WACC.
  • Provide an overall explanation for your results and how the firm may use this WACC.
  • Don’t forget your paper conclusion.

Calculations may be submitted on a separate Excel spreadsheet, with your explanations written in your paper.

TEXT BOOK : Berk, J., & DeMarzo, P. (2019). Corporate Finance (5th ed.). Pearson Education (US). (Mandatory) and other references

Using the financial functions of Excel and/or the formulas for TVM, solve each of the problems. Show all work by writing it out OR through the Excel functions you use to calculate the answer in your cell.

/in /by

Debt and Equity Financing

Using the financial functions of Excel and/or the formulas for TVM, solve each of the problems. Show all work by writing it out OR through the Excel functions you use to calculate the answer in your cell. Enter answers into each colored cell.

Compare and contrast basic U.S. and international financial accounting standards. Explain how key international factors affect business reporting. Identify key compliance and regulatory requirements.

/in /by

Unit 4 Project

International versus U.S. Accounting Standards For this assignment, you will research and compare international and U.S. accounting standards. This will enable you to see how the different reporting methods affect business and how product costs are affected by international business. The learning objectives of this report are as follows: Compare and contrast basic U.S. and international financial accounting standards. Explain how key international factors affect business reporting. Identify key compliance and regulatory requirements. Using the Unit IV Research Report Template, prepare a four- to five-page written report with at least three scholarly sources covering the items listed below.

Introduction Part 1: Select financial statements for two related (e.g., computer manufactures, pharmaceutical companies, cell phone companies, etc.) businesses; one that uses U.S. accounting reporting and the other that uses international accounting reporting. Identify the following items: Provide the name, location, and accounting standards used for each business. Compare and contrast three major differences you see in the way the financial data is presented on the financial statements. Identify which set of financial statements you think is the easiest to understand and provides you with most accurate cost data as a manager. (Do not forget to look at the notes to the financial statements also.)

Part 2: Analyze and discuss three international factors you think would affect the cost of the products made at the companies you selected and why.

Part 3: Discuss any compliance and/or regulatory issues you think would be involved in the companies you have selected as they relate to the cost of the products made. For example, are there strict regulations on product pricing, tariffs imposed on raw materials needed to make the products, or strict regulations on the wages paid to workers? Conclusion and Recommendations Be sure to use APA formatting throughout

Create a name and establish a location for the business. Construct a mission statement for the business. Decide on the type of cookie you want to make and sell.

/in /by

Unit 2 Accounting Project

Instructions

Cookie Business
In this project, you will be opening your own specialty cookie company to see how product costing methods and changes in production affect business decisions. You will be creating a series of reports and analyzing the results using the template provided to guide you through the project.
The learning objectives of this project are as follows:
Gain an understanding of product costing (direct materials, direct labor, and overhead).
Review job order costing.
Review process costing.
Make business decisions based on analyzing accounting data.
You will prepare a four- to five-page written report (including spreadsheets) with at least two scholarly sources using the Unit II Project Template . Your report will provide the following information:

Introduction
Part 1: Establish a cookie business selling only one type of specialty cookie with two employees making the cookies.
Create a name and establish a location for the business.
Construct a mission statement for the business.
Decide on the type of cookie you want to make and sell.

Part 2: Develop costing and sales information for 1,000 cookies.
Estimate and explain the cost per cookie based on job order costing (manufacturing overhead is 30% of direct labor costs). Prepare a job order cost sheet by researching and identifying the top five ingredients and their estimated costs as your direct materials. Research and identify the cost of wages for your two employees as your direct labor. It typically takes two days to make 1,000 cookies.
Estimate and explain the cost per cookie based on process costing with 40% conversion costs. Identify the top three processes you feel are needed to make the cookies and prepare a production cost sheet for one of those processes.
Estimate and explain the sales price you plan to set per cookie based on the cost data.
Part 3: Compare and contrast the costing methods used in this project, including which you believe provides the most useful information as a manager.
Part 4: Discuss what will happen to revenue if the number of the cookies sold increases or decreases.

Conclusion and Recommendations
Use the Unit II Cookie Project Spreadsheet Templates for your job order, and process costing spreadsheets to be embedded in your case study document.
Be sure to use APA formatting throughout and reach out to the Writing Center or the Library for assistance with research, writing, and formatting. Include at least two resources from the CSU Online Library in your report.

Based on the attached document from the Small Business Administration, document the advantages and disadvantages of different business entity types.

/in /by

Reflection – Entity Types

Based on the attached document from the Small Business Administration, document the advantages and disadvantages of different business entity types.

Determine the impact of economic costs on organizational and individual decision making. Explain how market structure impacts a business’s entry and exit into a market and its ability to generate economic profit.

/in /by

Competencies

In this project, you will demonstrate your mastery of the following competencies:

Inform business decisions using microeconomic models and theories
Determine the impact of economic costs on organizational and individual decision making.
Explain how market structure impacts a business’s entry and exit into a market and its ability to generate economic profit.

Scenario
You and your friend from college have just graduated. You majored in business, and your friend majored in a creative field. Your friend is highly inventive and has come up with an excellent idea for a new product. You both believe in this idea so much that you have agreed to become business partners. However, before you embark on your entrepreneurial adventure, you will have to explain some key microeconomics concepts to your partner that are important to make sound business decisions.

Your business partner is less than enthusiastic about this prospect and has never had an interest in what is often described as the dry and boring field of economics. Every time you have tried to engage your partner in practical discussions, they brush you off and decide to go play video games instead.

Aha! This gives you an idea: What if you could convince your friend to learn about economics through games? You have found several simulation games that demonstrate in real and interesting ways the economic principles that you know your partner needs.

Once you have played the games, you will create a memorandum report summarizing for your friend the educational value of your experiment. In your memorandum, you will restate the key principles and takeaways of each simulation, as well as illustrate how these ideas are relevant to your future entrepreneurial success.

Directions
First, assemble the materials that you will need to complete this assignment:

You will need several simulation report images for your memorandum. All the necessary data visualizations will be generated after you have completed each simulation game. You will be required to save image files of your simulation reports for your simulation discussions. These should also be used to create your memorandum report for the course project. If you have any questions or concerns about the simulation data that should be used for your project, you should promptly reach out to your instructor.
Review and use the Project Template located in the What to Submit section.

You are expected to reference any source material used in your memorandum report with appropriate citations. To support you, a References page has been added to the project template with a citation for this course’s reading already provided. Any other references you add should be cited according to APA format.
Once you have assembled the required materials listed above, you can now begin drafting your memorandum report by completing the following steps:

Comparative Advantage: Discuss the Comparative Advantage (With Trade) simulation that you played in Module Two. You should add the Production Decisions graph and the Production Trade graph (i.e., the graph showing how many hamburgers per fries) from you simulation report into the project template as Figures 1.1 and 1.2. Then, answer the following questions in the paragraphs below the figures:
How does this simulation demonstrate how individuals evaluate opportunity costs to make business decisions? Use the Production Decisions graph from the simulation as a reference to explain what role the production-possibility frontier (PPF) has in the decision-making process.
Explain how comparative advantage impacts a firm’s decision to engage in trade. Would a business’s decision to trade cause a change to its PPF? Provide specific reasoning to support your claims.
Competitive Markets and Externalities: Discuss the Competitive Markets and Externalities simulations (both with and without policy interventions) that you played in Modules Three and Four. Add the Supply and Demand chart and the Outcomes by Market table from your simulation reports into the project template as Figures 2.1 and 2.2. Then, answer the following questions in the paragraphs below the figures:

What impact do policy interventions have on the supply and demand equilibrium for a product? Provide specific examples from the simulation to illustrate.
What are the determinants of price elasticity of demand? Identify at least three examples. Based on the outcome of the simulation, explain how price elasticity can impact pricing decisions and total revenue of the firm.

Based on the results of the simulation, can policy market interventions cause consumer or producer surplus? Explain why using specific reasoning.
Production, Entry, and Exit: Discuss the Production, Entry, and Exit simulation that you played in Module Five. Add the Aggregate Outcomes chart from your simulation report into the project template as Figure 3.1. Then, answer the following questions in the paragraphs below the figure:

Analyze a business owner’s decision making regarding whether to enter a market. For example, what factors determined the driver’s market entry and exit in the simulation? Use economic models to support your analysis.
How does a business owner applying the concept of marginal costs decide how much to produce? For example, how did the driver determine how many hours to drive each day? Use economic models to explain.
How does the impact of fixed costs change production decisions in the short run and in the long run? Use the average-total-cost (ATC) model included in the module reading chapters to demonstrate this impact.

Market Structures: Discuss the market structures simulations (Price Discrimination and Cournot) that you played in Modules Six and Seven. Then, do the following in the project template:
Complete Table 4.1 as a reference guide for your business partner. The table should compare the attributes of each of the four listed market structures.
Answer the following questions in the paragraphs below the table:
Explain what market inefficiencies derive from monopolies and monopolistic competition. Use examples from the textbook to support your claims.
How do firms in an oligopolistic market set their prices? Use specific examples from the simulations or from the textbook to support your claims.
Explain how firms that compete in the four different market structures determine profitability. Use specific examples from the simulations or the textbook to support your claims.
Conclusions: Draw your overall conclusions about the relevance and significance of microeconomics. How will microeconomics principles impact your business decisions moving forward? Provide recommendations to your business partner for your future business venture.
Finally, ensure that all of your sources are properly cited using in-line citations and references according to APA format.

Explore some ethical dilemmas that students may face in the “real world.” Provide a discussion of the alternative courses of action and why you did not choose those.

/in /by

Clarence Hall University and the Donation

Clarence Hall University and the Donation from Darden Business Publishing, UVA, at the following link: http://store.darden.virginia.edu/clarence-hall-university-and-the-donationLinks to an external site.

Instructions:

This case is intended to explore some ethical dilemmas that students may face in the “real world.” You are to address the following question: What is the best course of action? To successfully to do this, you must take a stance, provide an answer, and support your answer with sound ethical reasoning identifying and taking into account all stakeholders. In addition you should provide a discussion of the alternative courses of action and why you did not choose those. Some additional reminders:

Your submission should be professional, organized, etc. using appropriate grammar, spelling, and professional, clear, concise writing.

Q3Arshan Industries is a division of a major corporation. Last year the division had total sales of $23,380,000, net operating income of $2,828,980, and average operating assets of $7,000,000. The company’s minimum required rate of return is 12%. What is the division’s return on investment (ROI)?

/in /by

Accounting Question

Q1. Unfavorable variance that occurs when:

  1. actual costs are greater than budgeted costs.
  2. actual costs are lower than budgeted costs.
  3. actual costs equals budgeted costs.
  4. actual costs are lower than sunk costs.

Q.2 A continuous (or perpetual) budget:

  1. is prepared for a range of activity so that the budget can not be adjusted for changes in activity.
  2. is a plan that is updated monthly or quarterly, dropping one period and adding another.
  3. is a strategic plan that does not change.
  4. is used in companies that experience no change in sales.

Q3Arshan Industries is a division of a major corporation. Last year the division had total sales of $23,380,000, net operating income of $2,828,980, and average operating assets of $7,000,000. The company’s minimum required rate of return is 12%. What is the division’s return on investment (ROI)?

Q4 Prepare a balanced scorecard with an example of your own.