ACCOUNTING WORK FOR WAQAS1ACA ONLY

Assignment 3: Excel Problems

At the end of each module, you will apply the module’s concepts by completing comprehensive assignments from the textbook.

Complete problems P21-20A (p. 1121), P21-21A (p. 1122), and P21-22A (p.1123)  in your textbook.

Present your analysis of the assigned problems in Excel format. Enter non-numerical responses in the same worksheet using textboxes.

If you need assistance with using Microsoft Excel, refer to the tutorials button above to find the Lynda.com section of tutorials. Search for Excel 2007 and Excel 2003 Essential Training.

By Wednesday, September 9, 2015 deliver your assignment to the M4: Assignment 3 Dropbox. Create the file with the following name: LastnameFirstInitial_M4A3.Excel.xls.

Assignment 3 Grading Criteria

Maximum Points

P21-20A:

 

Prepared report for July 2011 which shows the performance of the Dayton store, the Ohio region and the company

10

Explained and justified if would investigate the Dayton store on the basis of the report

5

Explained if Doggy World should prepare a master budget and discussed the benefits of budgeting

5

P21-21A:

 

Prepared Clipboard Office Supply’s budgeted income statement for May and June

10

P21-22A:

 

Prepared schedules of budgeted cash collections, budgeted cash payments for purchases and budgeted cash payments for operating expenses

10

Prepared a cash budget and identified the cash balance as of June 30, 2011

10

 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"

In a newspaper article how do they tell the story? (Narrative) Can you think of any other ways that stories…

In a newspaper article how do they tell the story? (Narrative) Can you think of any other ways that stories are told in printed media
 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"

4. Mel Sturbridge needs $24,700 to remodel his home. Find the face value of a simple discount note that will…

4. Mel Sturbridge needs $24,700 to remodel his home. Find the face value of a simple discount note that will provide the $24,700 in proceeds if he plans to repay the note in 180 days and the bank charges an 8% discount rate.
 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"

Intermediate Accounting I

You are the newly hired accountant for The Gift Shop. The owner has just received the December 31, 2008 bank statement and has asked you to prepare the monthly bank reconciliation.

 

  •      Write the procedure documentation for the monthly bank reconciliation process in a professional manner.
    •      It will be the desktop guide used by others in the event of your absence to prepare the financial statements for The Gift Shop.
    •      It may be in the form of a memorandum or as a numbered listing of items, depending on your individual preference.
  •      Prepare the monthly bank reconciliation for The Gift Shop based on the information provided.

Additional information needed for bank reconciliation preparation follows:

  •      Cash per the unadjusted trial balance is $12,675.
  •      Cash balance per the bank statement is $12,780.
  •      Check #115 has not cleared the bank. It was written for $645.
  •      A deposit of $1,000 cleared the bank but was not recorded in the general ledger.
  •      A check for $250 was found in the owner’s desk drawer.
  •      A deposit of $1,250 was taken to the bank after 2 p.m. on December 31, 2008 and was not posted by the bank until January 1, 2009.
  •      Errors were noted in the following checks:
    •      Check #121 was recorded for $325 but cleared the bank as $320.
    •      Check #125 was recorded for $585 but cleared the bank as $600.
    •      Bank service charge reported on the bank statement $30.00

 

 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"

Summative Assessment

The multiple choice answers has been done i need the SA Type questions and Case studies to be done

 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"

Employee Compensation Benefits 1

StopNShopToday, Inc., founded in 1991, is a family-owned corporation with 15 combination convenience store/gas station locations and approximately 150 employees. A store manager is responsible for each store location. All accounting, budgeting, payroll, human resources, bulk ordering, energy corporation franchising, and overhead costing is handled at the corporate office.

The company currently uses a loosely structured management training program to develop future store managers. The program consists solely of assistant managers who have been hired or promoted from cashier positions. These individuals learn managerial skills and functions through on-the-job training during a 1–2 year period. The minimum qualifications for the management training program are that the applicant has a bachelor’s degree (no specific curriculum), 6 months experience as a cashier, demonstrated dependability, and good customer service skills.

During the management training period, the assistant manager is responsible for the following:

  • compiling the store’s weekly employee shift schedule
  • filling scheduling holes
  • interviewing cashier applicants
  • making recommendations for hiring
  • totaling each shift’s cash register receipts
  • observing the duties and activities of the store manager

Most of these functions are handled in the office in the back of the store. Each store manager handles the training process based on his or her own individual preference and needs. Approximately 20 to 30% of the assistant manager’s week is spent on these functions. When not performing these tasks, the assistant manager performs the role of the cashier. Overall, an assistant manager will work between 50–60 hours per week, depending on the number of unscheduled absences by cashiers. Although the cashiers report solely to the store manager, they are expected to follow the instructions of the assistant manager.

The assistant manager’s position is salaried between $21,800 and $32,000 annually and is exempt from overtime pay rates. When a cashier is promoted to an assistant manager, he or she generally receives a $1.00 per hour pay increase, which generally results in an offset of the lost overtime pay he or she would have received for the same amount of work. The pay increase is intentionally structured in this way because the main motivation for employees taking the promotion is to become a store manager with StopNShopToday, Inc.

In this assignment, you will assume the role of a StopNShopToday, Inc. corporate human resources generalist. You have been assigned the responsibility of performing an analysis of the assistant store manager position. You must determine if the position is in compliance with the federal Fair Labor Standards Act (FLSA).

 

  • Create a memo to the vice president of human resources summarizing your interpretation of the requirements of the FLSA as the requirements apply to this position.
  • Segregate your findings into a minimum of 5 bullet points, and provide an introduction, summary, and recommendation(s).
  • Use the library and Internet to locate specific information on the requirements of the FLSA. It is recommended that you begin your search at the U.S. Department of Labor Web site. 

6-8 PARAGRAPH

 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"

Which tool is most important to ensure academic success: note taking, memory techniques, listening skills, or reading skills? Explain and…

Which tool is most important to ensure academic success: note taking, memory techniques, listening skills, or reading skills? Explain and support your answer.
 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"

Researcher_D Only

Deal is done…

 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"

bus 401 finance

 Investors will make an investment if:

 

the historical rate of return exceeds the expected rate of return.
the required rate of return exceeds the expected rate of return.
the expected rate of return exceeds the actual rate of return.
the expected rate of return exceeds the required rate of return.

 In the Capital Asset Pricing Model, the market risk premium is best approximated by:

 

the most recent one-year return on the S&P 500 Index (or another market index).
the long-term historic return on a stock market index such as the S&P 500 (or another market index). 
the long-term average spread of the S&P 500 (or another market index) over the yield of long-term government bonds.
the return of the S&P 500 (or another market index) over the current yield of long-term government bonds.

 

 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"

For ASTROLOGER ONLY.

Unit VI, chapter 7 & 8 homework and quiz. Due by the 23rd of July 2013.

 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"