10.3 Excel Problem
The Moose Wings Cooperative Flight Club owns a number of airplanes and gliders. It serves fewer than 2,000 members, who are numbered sequentially from the founder, Tom Eagle (0001), to the newest member, Jacques Noveau (1368). Members rent the flying machines by the hour, and all must be returned on the same day. The following six records were among those entered for the flights taken on September 1, 2010: Member # | Flight DateMM/DD/YY | Plane Used | Takeoff time | Landing time | 1234 | 09/10/10 | G | 6:25 | 8:46 | 4111 | 09/01/10 | C | 8:49 | 10:23 | 1210 | 09/01/10 | P | 3:42 | 5:42 | 0023 | 09/01/10 | X | 1:59 | 12:43 | 012A | 09/01/10 | P | 12:29 | 15:32 | 0999 | 09/01/10 | L | 15:31 | 13:45 |
…show more content…
In this case, it checks the cell containing the plane code to verify that it is only 1 letter. If the test is true, no error message is displayed (the second argument of the IF statement has two double-quotes). If the test is false, it displays the error message in the third argument of the IF function.
Field 4 - Time of take off: * Field check to verify that the field contains valid time format.
Field 5 - Time of landing: * Field check to verify that the field contains valid time format. Same as for field 4 * Reasonableness test that field 5 is greater than field 4.
a. Suggest other controls to minimize the risk of input errors. * prompting to request each required input item. * preformatting to display an input form including all required input items. * completeness check on each input record to ensure all item have been entered. * default values such as today’s date for the flight date. * closed-loop verification (member name would appear immediately after the member number)
10.10 Excel Problem
Creating and testing check digits.
a. Create a spreadsheet that will take as input a
You have been assigned to analyze the accounting information for a Fortune 500 corporation. From the e-Activity, evaluate which tools you would use to analyze its business processes, indicating your rationale.
To successfully implement change, employees need to understand how this will benefit them and impact their daily work. One of the things is that something might look good on paper can have drawbacks that are not realized by the planners, but can be easily identified by the employees who must implement the change. Therefore as a manager you need to bring the idea to the employees and get their feedback and continue to empower the employees to make the change that will work for them. Since change doesn’t happen overnight a manager needs to continually in monitoring the process and to assist the
Sony have been known worldwide as a Japanese multinational company, its efforts trying to expanding business in United States, have made that Sony acquires CBS Records and Columbia Pictures. Thus, creating Sony Music and Sony Pictures, which represent Sony entertainment. This involved to the company in $1.2 billion of debt, and assigned goodwill assets for $3.8 billion.
a. The times are a population because we are considering the wait times for all of the customers seated on Saturday night.
The week four individual paper addresses the implementation of Activity Based Costing (ABC) by Super Bakery, Inc., a virtual corporation founded by Franco Harris. Specifically, management strategies, the reasoning behind an ABC system, and the alternatives of a job order cost system or a process order cost system are assessed for this enterprise.
Bixton Company’s new chief financial officer is evaluating Biston’s capital structure. She is concerned that the firm might be underleveraged, even though the firm has larger-than-average research and development and foreign tax credits when compared to other firms in its industry. Her staff prepared the industry comparison shown here.
Only the incremental costs and benefits are relevant. In particular, only the variable manufacturing overhead and the cost of the special tool are relevant overhead costs in this situation. The other manufacturing overhead costs are fixed and are not affected by the decision.
Recognizing an organization’s alternatives for growth is an important process for companies. By evaluating and selecting the competitive advantages within a market a company can distinguish themselves from their competition. For an organization the “grand strategies indicate the time period over which long-range objectives are to be
The danger in using/ smoking tobacco starts at a young age until the adult age. Smoking can cause bad illness while also harming the person body and body organs. Smoking not only affects the person that uses, it also affects the people around you daily. Using tobacco can cause premature death too both the smoker and the nonsmoker, it called (second hand smoke). Tobacco smoking has been known to cause over 400,000 deaths every single year in the U.S (Wiley, 2011). People use tobacco smoking for many of reasons, some just for being cool, or trying to just fit in, and also watching family member smoke. Even though people know the bad and unhealthy
Before diving directly into the article from the Governmental Accounting Standards Board (GASB) titled Governments to Report Liabilities Connected with Their Obligations to Clean Up Pollution (2006), one must first take a step back and take time to read, comprehend, and take to heart exactly what this organization stands for. Taken directly from their main web page under the tab labeled Education, the first thing seen in big, bold, blue letters is, “Due Process: The GASB Is Listening” followed by a definition of what listening means, “to hear with thoughtful attention”. When researching a little more into the GASB, it is easy to see how crucial listening truly is for them in order to fully accomplish their
Our victim is a young girl who likes to promote fund raising events using social media. Our victim made a complaint to the local police department alleging that someone she knows is harassing her and defaming her good name online. The victim was asked to come into the Police department for an interview. During the interview our investigator learned that our victim has been receiving excessive unwanted intimate proposals, and altered indecent pictures using her face and also pictures of a person’s body parts via the internet. Investigators also learned that prior to
Activity-based costing (ABC) methodology is an instrument designed to provide accountants and managers with valuable costing information that will allow them to make sound strategic decisions. It is used as a secondary methodology rather than a replacement for the company’s primarily costing system. The ABC methodology identifies activities in an organization and for each activity it assigns a cost. The cost reflects the actual resource consumption by each activity that has been identified.
Do you feel that there might be an ethical issue present? For the moment, assume that no laws have been broken and just focus on any possible ethical issues.
14. By dragging the forumula from cell B11 to cells C11:F11, this provided the right value for the total sales of the boxes of Birthday cards, All Occasion cards, Thank You cards, and Mixed Cards 118, 69, 90, & 83.
Which of the following would not be considered an external user of accounting data for the Julian Company?