Reference no: EM131356958
REQUIRED: Using the database software indicated:
a. Create the "structure" for the records in the customer file. Use given Figure as a general guide to the data elements to be included in the customer records. However, observe the following specific requirements:
(1) Devise your own coding scheme for the "customer number."
(2) For the customer address, provide three separate fields, one each for street address, state, and ZIP code.
(3) Provide for two additional data elements that are not shown in given Figure (because they normally would be accessed from other files)-open sales orders and accounts receivable balance
b. If the software package supports a function to design input screens, create the screen format to be used for entering customer data.
c. Create hypothetical customer records and key the data into the database. The only design constraint is to use a variety of names, street addresses, states/ZIP codes, open sales order amounts, accounts receivable balances, and credit limits. (The number of records will be indicated by your instructor.)
d. Obtain a printout of the database records.
|
What is the bottleneck time
: A production process at Kenneth Day Manufacturing is shown in Figure. The drilling operation occurs separately from, and simultaneously with, sawing and sanding, which are independent and sequential operations. What is the bottleneck time
|
|
Explain which approaches you would be most comfortable using
: Identify the six possible approaches to the way in which the design work can be organized. Explain which approaches you would be most comfortable using.
|
|
Compute the? bond yield to maturity
: ?(Bond valuation? relationships) The 17?-year, ?$1,000 par value bonds of Waco Industries pay 7 percent interest annually. The market price of the bond is ?$1,135?, and the? market's required yield to maturity on a? comparable-risk bond is 4 percent...
|
|
Calculate the predetermined overhead rate
: Calculate the predetermined overhead rate that would be used under traditional overhead costing - Calculate the product cost per unit for the Basic and Advanced products under traditional costing
|
|
Create the structure for the records in the customer file
: Create the "structure" for the records in the customer file. Use given Figure as a general guide to the data elements to be included in the customer records. However, observe the following specific requirements:
|
|
How the selected company can establish hrm strategies
: Determine which HR job positions you would prefer and explain why. Analyze how the selected company can establish HRM strategies to improve competitive advantages.
|
|
What is the throughput time of the new work cell
: The Pullman Mfg., Inc., three-station work cell illustrated in Figure has two machines at station 1 in parallel. What is the throughput time of the new work cell? What is the bottleneck time of the new work cell
|
|
What must the risk-free rate be
: A stock has an expected return of 15.9 percent, a beta of 1.70, and the expected return on the market is 10.10 percent. What must the risk-free rate be?
|
|
What is target variable cost per mouse
: A company believes it can sell 5,600,000 of its proposed new optical mouse at a price of $10.00 each. There will be $8,000,000 in fixed costs associated with the mouse. If the company desires to make a profit $2,000,000 on the mouse, what is the targ..
|