Find Jobs
Hire Freelancers

excel expert needed for a quick work

₹100-400 INR / hour

已关闭
已发布超过 5 年前

₹100-400 INR / hour

A new client of yours, Blanche Greene, wants to open a small diner selling calamari, oysters, fried shrimp, catfish sandwiches, salads, French fries, and sodas. He is planning to open the diner on the July 1, 2018. You, as an independent consultant, have been hired to develop a cash pro forma budget for his business venture (note: this is a spreadsheet that helps forecast income and expenses over a period of time). It can be used to plan for and manage the business if done correctly. Assignment: Using Microsoft Excel, construct a monthly proforma cash budget for your client for the first year of operations. Use the attached Excel Template - “Excel Assignment Diner Template” as your starting point. This is the file that must be downloaded and used as the basis for your assignment. Do not make any changes to this pre-designed template except to add your information for the diner. Do not use a template from a previous semester – this is considered academic dishonesty and will be subject to disciplinary action. Place the finished cash pro forma on a worksheet labeled “Cash ProForma". Place all your case assumptions data on a separate worksheet. Label the worksheet "Assumptions" (note: each piece of data must appear in its own cell on the Assumption sheet). Place your start-up costs on a third worksheet labeled "Startup Costs" Create two additional worksheets for your recommendations. Label one worksheet “Beer Recommendation”, label the other “Entertainment Recommendation”. Appropriate Charts (graphs): You will be creating two separate charts so create and label two additional worksheets for the charts (each chart will be in its own worksheet). Chart One –”Monthly Product Revenue” – this will show the monthly revenue for each of your five products for the entire year. 2 Chart Two – “Total Product Net Income” - You want to track the total product net income for the year to determine any trends or projections in product sales. Make sure both charts are formatted correctly (i.e. appropriate title, legend where appropriate, data series properly labeled) and they are appropriate for business use. Information needed to complete assignment: Calamari, Oysters, Fried shrimp, Catfish sandwiches, Salads, French fries, and sodas. Product Selling Prices: Oysters on half shell will sell for $8.25 each (dozen) Fried Shrimp will sell for $10.25 (dozen) Calamari will sell for $4.95 an order Catfish Sandwich will sell for $5.95 Salads will sell for $4.50 each Fries sell for $1.25 per order Sodas sell for $1.25 a bottle Cost of Goods Sold: The Catfish sandwich ingredients (fried catfish, cheese, sauce, bun etc.) cost $3.15 per sandwich. Calamari cost per order $1.90. The fresh Shrimp cost $7.19 per order from the supplier. Oysters (sauce, lemon, oysters) cost $5.19 per order. Salad ingredients (lettuce, tomatoes, cheese, etc.) cost $1.23 per salad serving Frozen fries and oil average to $.67 per order Sodas cost about $.7 per 16 oz. bottle The building rent is $2775 per month. Phone will cost about $220 per month. Electricity should cost about $775 a month. Insurance will be $850 a month. Demand Rate:
项目 ID: 17341098

关于此项目

7提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
7 freelancers are bidding on average ₹366 INR/小时 for this job
用户头像
Yes will be done in Rs 6000/- I will take 15 hours to finish.........................................................................
₹400 INR 在15天之内
4.4 (73条评论)
5.9
5.9
用户头像
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have Microsoft certifications in .Net development and sql server. I also have a lot of experience in desktop and web development. Regards
₹277 INR 在40天之内
4.8 (25条评论)
4.9
4.9
用户头像
Hello. I am Edgar Díaz. I am Urban Planner With a MBA and Specialist in Project Management (PMI). I have experience in accounting and bookkeeping. I am AIPB, AAA, ACCA student
₹250 INR 在40天之内
4.9 (31条评论)
4.8
4.8
用户头像
Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satisfied client. I am regularly doing following kind of tasks: Using Microsoft Excel, construct a monthly proforma cash budget for your client for the first year of operations. Thanks. Faisal S.
₹1,111 INR 在40天之内
5.0 (9条评论)
3.1
3.1
用户头像
Hey. I read your project details and I am interested in your project so please message me and we discuss about the project. Thank You, Tahir M. ........
₹111 INR 在40天之内
1.5 (3条评论)
2.9
2.9

关于客户

INDIA的国旗
Calcutta, India
4.7
183
付款方式已验证
会员自1月 29, 2011起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。