All categories

20 days ago

You have been hired to design a relational database for a convenience store which is located within an apartment complex. The go

al of the database is to keep track of the inventory sold in hopes of using the data to better meet the customer's convenience store needs. Up until your arrival, the store kept track of each customer’s purchases using a flat database log, as shown in the following table. Using the information provided, build a relational database that will allow for querying things such as products sold, customer purchases, total apartment purchases, and total spent per apartment. Include any created tables and identify the keys and key types that are used. Identify all relationships, labeling them 1:1, 1:N, or M:N.
Name Apt # Products Price Quantity
Joseph Anthony 1125 Orange Juice 4.59 1
Joseph Anthony 1125 Bread Loaf 2.29 1
Yolanda Burns 3221 Milk 3.67 1
Yolanda Burns 3221 Candy Bar 1.19 3
Francis Jordan 1138 Gum 0.99 2
Steve Miller 2221 Gum 0.99 1
Cho Lin 2239 Bread Loaf 2.29 1

Business

You might be interested in

Derrick was feeling drained after working for several hours on a demanding task that required intense concentration. Derrick the

stepan [3596]

The force of positive energy and motivation significantly impacts behavior. A positive energy encompasses traits such as enthusiasm and optimism that individuals aspire to embody. Motivation functions as a method incentivizing individuals to cultivate positivity and effectively achieve their objectives. In this scenario, Daisy indirectly encouraged Derrick, instilling motivation through her upbeat dialogue, resulting in Derrick's renewed focus and productivity.

8 0

2 months ago

The tool crib at a large manufacturing company is responsible for providing tools to the factory workers on demand. The tool cri

Nady [3600]

Answer:

6.4 minutes

Explanation:

Daily average for small tools = 445

Working hours = 8, which translates to 8*60 = (480 minutes)

Waiting time =

$\frac{[445*(\sqrt{1} )]}{[2*[480-(445*1)]]}$ (image of the operation in the attached file)

= [445]/[(2*35)]

= 445/70

= 6.357 minutes

3 0

3 months ago

Mason Company has two manufacturing departments—Machining and Assembly. The company considers all of its manufacturing overhead

soldi70 [3635]

Answer:

(a) Predetermined overhead rate for the entire plant:

$=\frac{Total\ manufacturing\ overhead}{Total\ direct\ labor\ hours}$

$=\frac{23,400,000}{780,000}$

= 30

Applied manufacturing overhead for Job A:

= Total hours of direct labor × Predetermined overhead rate for the plant

= 15 × 30

= 450

Applied manufacturing overhead for Job A:

= Total direct labor hours × Plantwide predetermined overhead rate

= 9 × 30

= 270

(b) Department-specific predetermined overhead rates:

$Machining =\frac{Manufacturing\ overhead}{Machine\ hours}$

$Machining =\frac{22,500,000}{750,000}$

= 30

$Assembly =\frac{Manufacturing\ overhead}{Labor\ hours}$

$Assembly =\frac{900,000}{750,000}$

= 1.2

Applied manufacturing overhead for Job A:

= (Machining machine hours × 30) + (Assembly direct labor hours × 1.2)

= (11 × 30) + (10 × 1.2)

= 330 + 12

= 342

Applied manufacturing overhead for Job B:

= (Machining machine hours × 30) + (Assembly direct labor hours × 1.2)

= (12 × 30) + (5 × 1.2)

= 360 + 6

= 366

4 0

4 months ago

Espinoza Company is a wholesale distributor that uses activity-based costing for all of its overhead costs. The company has prov

marusya05 [3725]

Answer:

Espinoza Company

The activity rate for the order fulfillment cost pool:

Expenses associated with fulfilling orders divided by the number of orders

= $130,500/3,500

= $37.29 per order

Explanation:

a) Relevant data and calculations:

Overhead expenses:

Salaries and wages: 220,000

Other expenses: 150,000

Total: $510,000

Distribution of resource usage:

Filling Orders Activity Cost Pools

Filling Orders Customer Support Other Total

Wages and salaries 35% 55% 10% 100%

Other expenses 35% 50% 15% 100%

Fulfilling orders: 3,500 orders

Customer support: 15 customers

Overhead Allocation:

Filling Orders Customer Other Total

Support

Salaries and wages: $77,000 $121,000 $22,000 $220,000

Other expenses: $53,500 $75,000 $22,500 $150,000

Total: $130,500 $196,000 $44,500 $370,000

The activity rate for fulfilling orders is determined as $130,500/3,500, giving $37.29 per order.

Activity Based Costing (ABC) is a costing method that uses activity pools to gather and allocate overhead expenses based on the level of engagement for each activity pool.

3 0

3 months ago