Ask Question, Ask an Expert


Ask Managerial Accounting Expert

Check LiveText for due date and details on how to submit the assignment.  You must upload the assignment in LiveText in a single Excel file that contains three separate worksheets. You should name your file in the following manner:  “yourname_BA216_proj”. Your work product should demonstrate your proficiency at creating documents in Excel, including but not limited to formatting and formula use.
Below is the information needed to complete the special project relating to select accounting topics. No assistance should be sought from anyone except your instructor.

Financial information for the project:

1) You decide to open a small business in Charleston, WV that will cater primarily to busy office workers downtown.  You are going to offer a gourmet box lunch to be delivered to any office with a minimum number of 5 orders. This lunch will include a gourmet sandwich, a bag of chips, a cookie, and a bottle of water. Because you are using only the finest ingredients, you will charge $7.25 per lunch.

2) The cost of the food items (cost of goods sold) in each lunch is budgeted at $3.10. These are primarily perishable items, so inventory is negligible.  You pay for virtually all of your purchases by check at the time they occur.

3) You are planning on drawing out a monthly salary of $1200.

4) You are planning on hiring an assistant to help you with packing the box lunches and delivering them 20 hours per week at $7.60 per hour.  Assume four weeks in the month. Assume you will pay your assistant regardless of the hours they are actually needed. Treat this as a fixed cost.

5) You believe you must heavily advertise to get your business established. The amount you are willing to spend is 5% of your monthly revenue.  Even though you are using sales revenue to determine the dollar amount of your advertising, treat this as a fixed cost. Advertising costs are paid in the month incurred.

6) You have to pay rent on a commercial kitchen where you will store your items and prepare your box lunches. The rent is $400 per month. Rent is payable on the 1st day of the month.

7) You will rely on a fax machine to receive your orders. The cost of the phone line is $95 per month. Payment for the current month will occur in the next month when the bill is received.

8) You received an electric bill on the last day of the month payable on the 20th of the following month. It was for $235. Your electric usage is very stable; therefore you treat it as a fixed cost.

9) Sales are primarily cash. There are a few corporate clients you have extended credit to. You estimate 12% of total sales will be collected in the next month. Because this is the first month of operations, there are no outstanding accounts receivables. 

10) In order to deliver the lunches you have leased a delivery truck. The lease is a two-year lease at $375 per month. The variable cost of operating the delivery truck is $0.46 per lunch delivered. The lease payment is paid at the beginning of the month and all variable costs are paid as incurred.

11) Based on your business plan you drew up, you decided to invest $6000 of your own money to get your business started.  Prior to beginning business operations, you spent some of this $6000 as start-up costs (in prior months) leaving you with a cash balance at the beginning of the first month of operations of $2900.

Managerial Accounting, Accounting

  • Category:- Managerial Accounting
  • Reference No.:- M9154

Have any Question? 

Related Questions in Managerial Accounting

Accountingthree questions please provide references

Accounting Three questions please provide references where needed Financial statement analysis 1. The Financial Statement Analysis is the process of reviewing and evaluating the company's financial statements with the on ...

Formulate a search query to determine whether your client

Formulate a search query to determine whether your client is required to capitalize fringe benefits and general overhead that is attributable to employees who are building an addition to your client's factory during a "s ...

Median earnings the graph in the next column shows the

Median Earnings The graph in the next column shows the median earnings for females from 2005 to 2009 in constant 2009 dollars. (a) How is the bar graph misleading? What does the graph seem to convey? (b) Redraw the graph ...

1 an accrual of wages expense would produce what effect on

1. An accrual of wages expense would produce what effect on the balance sheet? A. Increase liabilities and decrease equity B. Decrease liabilities and increase equity C. Increase assets and increase liabilities D. Decrea ...

Equity method journal entries with intercompany sales of

Equity method journal entries with intercompany sales of inventory Assume that an investor owns 35% of an investee, and accounts for its investment using the equity method. At the beginning of the year, the Equity Invest ...

Elroy who is single has taken over the care of his mother

Elroy who is single has taken over the care of his mother Irene in her old age. Elroy pays the bills relating to Irene's home. He also buys all the groceries and provides the rest of her support. Irene has no gross incom ...

Learning outcomeanalyse the issues or problems in a given

Learning Outcome: Analyse the issues or problems (in a given scenario) using management accounting techniques and tools, and formulate recommended solutions. Required: Write a short analysis based on the assignment detai ...

An article in cost management by kocakulah bartlett and

An article in Cost Management, by Kocakulah, Bartlett, and Albin entitled "ABC for Calculating Mortgage Loan Servicing Expenses" (July/August 2009, p. 36), discusses a use of ABC in the financial services industry. Instr ...

Belleview ltd is the parent company holding 80 percent

Belleview ltd is the parent company holding 80 percent interest in the James Hardy ltd. For each of the following independent cases, provide adjusting entries necessary to eliminate the effect of intragroup transaction a ...

Milestoneoverview the final project for this course is the

Milestone Overview: The final project for this course is the creation of a portfolio consisting of a report, spreadsheets, and a PowerPoint presentation. You will be placed in a real-world scenario in which you will take ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate