Bob’s Supply (BS) needs to keep track of the parts they have in their inventory. He wants to know the description of each part, the color of each part, how many of each item is in stock [QOH], and how much each part costs him.  BS also needs to keep track of who supplies each part, the supplier’s name, contact person, and telephone number.  We know that each part in inventory has only one supplier, but some suppliers supply multiple parts to BS. Bob wants each part and each supplier to be assigned a unique identifying number. Identify the tables needed to design the database and the fields [attributes] needed for each table and the role or function that some attributes take on.

Using the worksheet pictured​ above, answer the following​ questions: a. Describe the steps you would follow to create the Profit calculation portion of the worksheet. Within the Profit calculation portion of the worksheet​ pictured, which cells would contain​ formulas? Specify each cell that would contain a formula and what each of those formulas would be. b. Describe the steps you would follow to create the Data table portion of the worksheet pictured. c. What is the current break even volume of sales if the selling price remains at​ $50? How do you​ know? d. If the company raises the selling price to​ $60 and sells 600​ units, what would be the operating​ income? e. If the​ company's suppliers increase the cost of direct​ materials, would you expect the table to contain the​ same, fewer, or more shaded​ cells? f. If the company can negotiate lower plant property taxes with the​ county, would you expect the table to contain the​ same, fewer, or more shaded​ cells? g. If the company…

Draw clearly from existing scenario text the Entity Relationship Diagram (ERD) “There is a group of employees who have run the website. Three admins are responsible to check registration forms filled by babysitters.  An accountant is responsible to check fees payments. All these employees are supervised by the manager.    Each babysitter can register on the website one time by filling in her data including first and last names, qualifications, fee rate per hour (25 SAR per Hour), contact information, address, photo, and years of experience.  The system will issue for her id and registration date.   Mothers can make booking as many as they need.  For each time, they must fill in their names, contact information, address, number of children, the date and time (e.g. from 2:00 PM to 4:PM) of booking.    The website will generate the booking report including mother’s data, babysitter’s contact data, number of booked hours, fee rate per hour, fees total amount, and tax (%5).  To make a…

As of the time of writing, Damon Davis was completing out the paperwork for Drano Plumbing. He estimated a $50,000 net profit would be made. He counted the columns of the balance sheet and knew how much was in the credit column ($300,000) and how much was in the negative column ($400,000). What, in your opinion, was the most plausible reason for the discrepancy in the results? What should he do next to identify the issue's cause if this wasn't the cause of the issue?