Download the attached Excel file (First Q Profits Report W Goal Seek_Ver2.xlsx). Instructions: . There are 3 Worksheet Tabs in this Excel file; First Q, First Q Goal Seek, and Minivan Loan. • The First Q (First Quarter) tab shows the first quarter revenue and expenses of the Downtown Internet Cafe. For this tab, • Complete the Proportion column, cells G7 through G11 Each proportion value shows the % of the quarterly sale of that item over the entire sale. Calculate the Net Income row, cells B24 through F24. o Compute the Profit Margin row, Cells B25 through E25. o Add Net Income Sparkline for January through March in Cell H24. in For this tab

Ngai Nhung is the sales manager at Hung Technologies. At lunch with the company CEO, Ngai proudly announced that he had received a __ from a client. The client had just requested a large quantity of components from Hung. A. purchase order B. purchase requisition C. back order D. voucher E. bill of lading

Answer the following questions in a separate document. Explain how you reached the answer or show your work if a mathematical calculation is needed, or both. Submit your assignment using the assignment link. This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions. Please respond to the following: You have just won the Strayer Lottery jackpot of $11,000,000. You will be paid in 26 equal annual installments beginning immediately. If you had the money now, you could invest it in an account with a quoted annual interest rate of 9% with monthly compounding of interest. What is the present value of the payments you will receive? In your own words and using various bond websites, locate one of each of the following bond ratings: AAA, BBB, CCC, and D. Describe the differences between the bond ratings. Identify the…

Hey there.The question is in the attached document. Can you please answer this question in a spreadsheet-like manner and show the formulas?It's only through the formulas that I can truly understand and learn from your work.Please note that the question has five subparts. If you want, please deduct five questions from my total amount of 30 questions to be asked.I am looking forward to hearing from you.

GenX is a career training company that offers both online and on-campus weekend training courses on web development, data science, coding, and digital marketing. The accompanying data file shows the courses that will be offered next month by GenX. The data set contains course name (Course), whether the course is offered online or on-campus (Mode), current enrollment (Enrollment), tuition per student (Tuition), cost of instructors (Instructor costs), facility costs (Facility costs), technical service costs (Technical services), and historical cancellation rate for the course (Cancellation rate). Only on-campus courses incur facility costs. Online courses carry much higher costs for technical services than on-campus courses. The historical cancellation rate is used to project the actual enrollments of the courses. GenX would like to develop a spreadsheet model that calculates the projected revenue and profit for the month. Course Mode Enrollment  Tuition Instructor costs Facility…

Please help answer the Income statement. Use the data at the top of the schedule to complete the report. use the data from your cost of services provided schedule. The cost to use is: Daycare $18 - 22 dogs per day Boarding $25 - 12 dogs per day Grooming $25 - 4 grooms per day

Part of your job is to review customer requests for credit. You have three new credit applications on your desk and part of your analysis requires that the current ratlos and quick ratlos be compared.

Please help I am having trouble with this question. I will attach Images with better quality and some parts I have answered and parts I am missing. Thank you :)    Kim's Asphalt does driveway and parking lot resurfacing work for large commercial clients as well as small residential clients. An inventory of materials and equipment is on hand at all times so that work can start as quickly as possible. Special equipment is ordered as required. On May 1, the Materials and Equipment Inventory account had a balance of $39,000. The Work-in-Process Inventory account is maintained to record costs of work not yet complete. There were two such jobs on May 1 with the following costs.    Job 27Highlands Mall Job 33Pine Ridge Estates Materials and equipment $ 15,825   $ 52,800   Direct labor   13,800     26,400   Overhead (applied)   5,520     10,560       Overhead has been applied at 40 percent of the costs of direct labor. During May, Kim's Asphalt started two new jobs. Additional…

Create a flowchart for the following telephone-ordering process at a retail chain that specializes in selling books and music CDs. It provides an ordering system via the telephone to its time-sensitive customersbesides its regular store sales. First, the automated system greets customers and identifies whether they have a tone or pulse phone. Customers choose 1 if they have a tone phone; otherwise, they wait for the first available service representative to process their request. If customers have a tone phone, they complete their request by choosing options on the phone. First, the system checks to see whether customers have an existing account.Customers choose 1 if they have an existing account or choose 2 if they want to open a new account. Customers wait for the service representative to open a new account if they choose 2. Next, customers choose between the options of making an order, canceling an order, or talking to a customer representative for questions and/or complaints. If…