Which side of the argument do you take? Are there ways that we could change the scholarships that would make them more equitable? Explain.

Government Budgeting and Finance question

Read the Orlando Sentinel Article and the PowerPoint Presentation linked under Chapter 5.

The article and our research make the point that merit scholarships are a bad use of lottery revenues because they cause a “Reverse Robinhood” effect. The Orlando Sentinel got hundreds of letters to the editor objecting to the article when it was published in December 2022. The letters made the opposing points that the Bright Futures Scholarships reward students for their hard work, they lead to the best and the brightest students staying in Florida to go to college and then staying in the state to start their careers, and the awarding of the scholarships is color-blind and class-blind. There is nothing on the application that asks for the student’s race or income.

a. Which side of the argument do you take? Defend your answer.

b. Are there ways that we could change the scholarships that would make them more equitable? Explain.

Create one form for each operating event to record a new instance of that event (see Forms Lab). Create one form for each resource and agent table. Create a sub menu form for each operating event.

ACCT361: Accounting Information System Development Project Application of Business Processes and Embedded Controls

Scope:
This is an individual project that requires the development of an eventdriven IT application prototype for a business process in your assigned industry. The project will conclude in a demonstration of your working database.

The objective of the project is to:
Apply the cumulative instruction provided in this course to a final project that integrates your understanding of the course material and the database management skills presented throughout the semester.

Increase understanding of how technology affects organizations, and the varying information needs of different industries; and

Increase understanding of how the use of technology and the knowledge of business processes can help accounting professionals produce and deliver more valuable information.

Steps of the Project:

Using the information from course module material and the Access techniques learned in the Controls lab, Forms lab, Tables labs, Query labs, and Report lab, create the AIS database for your company’s partial sales/collection cycle. Use the following steps to work through completing your database:

1. (MS Word) Create the Logical model for your company from the REA model given for this project. This is Assignment 2. Make sure the names of your table and the attributes of the tables are customized to your assigned industry. Do not use “Item# or “Sales Clerk” primary key names be creative and have the names fit your industry. Also collect data on your customers which fit the needs of your industry.

2. (Access) From the Logical model:
Start with a new (blank) access database (DO NOT USE AN EXISTING COMPLETED OR PARTIALLY COMPLETED ACCESS DATABASE AND MAKE ALTERATIONS) and create all tables, complete with required attributes; primary keys, foreign keys, and nonkey attributes for each of the business events (including resources, agents) using a new Microsoft Access database.

3. (Access) Invoke realtime information risk controls. Your new tables should have the following internal controls implemented (see Controls Lab)
the Now Date for the Date field in your operating event tables

Auto number as the data type for the primary key for each of your two Operating event tables (see video about Auto number in Course Resources for system project folder)

Use input masks for the Zip Code, SS#, State abbreviation, and phone number in the tables containing these nonkey attributes

4. (Access) Establish Referential integrity (Tables Lab)

5. (Access) Complete your database.
Create one form for each operating event to record a new instance of that event (see Forms Lab)

Create one form for each resource and agent table. This is to allow adding a new resource or agents to the table via a form (not direct input like Step 4). Use this form to populate at least 10 records for each resource or agent table.

Create a main menu to be shown when your database opens (Controls Lab)

Create a submenu form for each operating event. These menu and submenu forms will help organize your system and allow access restrictions by making them password protected. A user of your system must be able to access all forms and reports using menus and not the database objects window. (Controls Lab)

Test the accuracy of your prototype. This will require you to use your operating event forms to add new records to each operating event table. There should be a minimum of 10 operating events for each operating event table created.

Password protect your database using the password: klam

Require a password before allowing access to your database (Controls Lab)

Hide the navigation pane from users (Controls Lab)

Create a minimum of two reports. Required Reports are:

o Sales by Customer Report (Query Lab)

o EQOH Report listing EQOH by total number of items and total dollar amount of items
(EQOH = Ending Inventory in US Dollars) (Query Lab)

Add custom logos, color, graphics, design to your database as desired.

Write a report on your experience and explain what costs JDI includes in its manufacturing overhead for the plant and how the costs are allocated to their products.

Virtual Factory Tour Reflection.

Write a report on your experience and explain what costs JDI includes in its manufacturing overhead for the plant and how the costs are allocated to their products.

Calculate the cash conversion cycle and how this has changed over time. Determine how this firm compares to others within their industry.

Business finance/ capital management strategy

Working capital management strategies can be different for every company. Choose a firm (this can be the one for your Financial Analysis project or a different company of interest to you) and review their financials over a 10 year period. Compare the changes that have occurred over this time frame. For example, review the 2010 financials for Walmart, and compare them to the financials for 2020, in terms of working capital. Your working capital analysis should include the following:

Your initial comments/impressions of the firm’s working capital policies

Overall level and change in working capital over the time period and the factors that contributed to these changes.

  • Calculate the cash conversion cycle and how this has changed over time.
  • Determine how this firm compares to others within their industry.

All sources used should be cited using APA formatting.This includes an in-text citation as well as a full citation section at the end of your posting. You must cite all sources referenced. the textbook is required: Global Business Today By Charles W. L. Hill

Perform an analysis to determine if Warren Sports has proper segregation of duties in these two cycles and conclude. If duties conflicts are noted, discuss the risk and conclude.

Segregation of Duties

Using your knowledge of Warren Sports and its three employees, including the flowcharts, perform the following SOD analysis for the purchasing/disbursements cycles:

1) Briefly list the key processes/activities/controls/or duties in each cycle.

2) Categorize the items listed in #1 as either Authorization, Custody, Recording, a Reconciliation, a Process or N/A.

3) Perform an analysis to determine if Warren Sports has proper segregation of duties in these two cycles and conclude. If duties conflicts are noted, discuss the risk and conclude.

Utilize three worksheets in a spreadsheet to analyze 1, 2 and 3 above. #3 may be a short essay (on tab 3 of your spreadsheet).

Use the cash disbursement and purchases on account to analyze

Determine the amount of revenue that the company needs to generate in a month to earn an operating profit of US$3,000. How much of this revenue will be generated from lab and scan services, respectively?

Realizing the Dream: Decision-Making in Action

  • https://www.studypool.com/questions/download?id=2755531&path=uploads/questions/6796467/20230225193847realizing_the_dream___decision_making_in_action.pdf&fileDownloadName=attachment_1

CASE QUESTIONS
1.
Identify and compute the various types of cost for the company according to cost behavior. Determine the monthly fixed and variable costs for scan and lab services that the company incurs.

2. Assume that GEO Medical Laboratory only provides scan services, and determine the breakeven in terms of units and sales. If the only services that GEO Medical Laboratory offers are lab services, determine the number of patients that the company would need to help in order to break even, as well as the break-even amount. Assume that the salary of the administrative assistant is evenly distributed between the two services and the usage of furniture and fittings, computer, and printer are equally shared. What does your answer imply?

3. Determine the cost structure of GEO Medical Laboratory. Is the company highly or lowly leveraged?

4. Assuming a multiproduct situation, how many patients and how much total revenue does GEO Medical Laboratory need to break even in a month?

5. How many patients must GEO Medical Laboratory attend to in a month if it wants to make a profit of US$3,000? How many of these patients should be scheduled for lab services and how many for scan services?

6. Determine the amount of revenue that the company needs to generate in a month to earn an operating profit of US$3,000. How much of this revenue will be generated from lab and scan services, respectively?

7. Based on quantitative calculations, should Wallas accept the school’s offer? Why or why not?

8. Besides profitability, what other motives might influence Wallas’ decision about the offer from the local school? Discuss how such offers might benefit (or harm) GEO Medical Laboratory.

9. Give Wallas at least three specific recommendations to increase revenue or to reduce the costs for his company. Which of these three recommendations do you think is the best for Wallas right now and why? Be clear about why this recommendation is preferred.

Calculate the contribution margin for each product based on your sales price and the variable cost for that product. Show your work using calculations to the side of the table or using appropriate formulas in the table.

4-2 Milestone Two: Cost-Volume-Profit Analysis

Use information from Milestone One and the provided Milestone Two Market Research Data Appendix Word Document to conduct a cost-volume profit analysis. Complete the “Contribution Margin Analysis” and “Break-Even Analysis” tabs in the Project Workbook Spreadsheet that you used for completing the Milestone One assignment.

Specifically, you must address the following rubric criteria:

Contribution Margin. Determine your contribution margin per unit in the “Contribution Margin Analysis” tab.
Choose a sales price for each product.
Calculate the contribution margin for each product based on your sales price and the variable cost for that product. Show your work using calculations to the side of the table or using appropriate formulas in the table.
Break-Even Analysis. Use cost-volume-profit (CVP) analysis to determine your break-even points for achieving your target profits in the “Break-Even Analysis” tab.
Determine the break-even points for each product. Show your work using calculations to the side of the table or using appropriate formulas in the table.
Determine break-even units for the suggested target profits for each product. Show your work using calculations to the side of the table or using appropriate formulas in the table.

Guidelines for Submission
Submit the Project Workbook with the “Contribution Margin Analysis” and “Break-Even Analysis” tabs completed. This file should be completed and submitted using Microsoft Excel.

What is specialized accounting system?

Accounting Question

What is specialized accounting system?

How much additional revenue must each company generate to recover the losses from the fraud? Why are these amounts different? Which company will probably have to generate less revenue to recover the losses?

The Case of Clever Inc

Clever, Inc., is a car manufacturer. Its 2015 income statement is as follows:

Clever. Inc. Income Statement for the Year Ended December 31, 2016 Sala moor 5204:00
Less cost of goods sold Coals =non Eapansis Nei income

Alexander, Inc, is a car rental agency based in Florida. Its 2015 income statement is as follows:

Alexander. Inc. Income Statement for the Year Ended December 31, 2016
Sala trent.. Events Net Income
S20.COD ISIXO

During 2015, both Clever, Inc., and Alexande , Inc, incurred a $1,000 fraud loss. 

  1. How much additional revenue must each company generate to recover the losses from the fraud?
  2. Why are these amounts different?
  3. Which company will probably have to generate less revenue to recover the losses?

Which customer had the highest average sales amount? What specifically was their average amount? Which employee had the highest earned commission? What specifically was their commission amount?

DISCUSSION QUESTION

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. Go to the Relationships screen and connect the five tables, enforcing referential integrity.
  • b. Calculate the total sales for each customer. Include CustomerlD and CompanyName from the Customer table and the calculated sale amount from the Sale_Amount_ Calculation query. Name the query Total_Customer_Sales.
  • c. Generate an e-mail user name for each employee using the first letter of the employee’s first name and the first five letters of the employee’s last name, e.g., Rod Smith = > rsmith. Include EmployeelD, EmployeeFirstName, and EmployeeLastName in the query. Name the query Employee_Email_Generator.
  • d. Calculate the total sales for each month.
  • e. Determine which customer had the highest average sales amount. (Hint Sort in descending order.)
  • f. Assume the employees earn a 5 percent commission on sales. Calculate the total commission due to each employee. Use two queries to do these calculations.

Required: 

  1. Which customer had the highest average sales amount? What specifically was their average amount? 
  2. Which employee had the highest earned commission? What specifically was their commission amount?