Case-m and m enterprise system

Assignment Help Business Management
Reference no: EM133040791

Examine the tables below for M & M Enterprise system first and answer the following questions.  

Vendor

Vendor Number

Name

Address

Other

44           

Danby

 

 

55

Milo

 

 

66

Dobbs

 

 

77

Aarfy

 

 

88

Daneera

 

 

99

McWatt

 

 

101

Sunny

 

 

Purchases

Purchase Number

Amount

Vendor Number

Other

1

6183

66

 

2

4756

101

 

3

2329

66

 

4

9842

55

 

5

3158

44

 

6

8378

66

 

7

5250

101

 

8

2222

101

 

Services

Service Number

Amount

Type

Vendor Number

1

225

Advertising

77

2

275

Advertising

77

3

2020

Cleaning

88

4

181

Transportation

55

5

862

Advertising

99

6

313

Transportation

55

7

310

Advertising

77

8

2020

Cleaning

88

9

1010

Installation

101

Cash-Disbursement

Check Number

Amount

Other

100

1010

 

101

6183

 

102

1010

 

103

2329

 

104

9842

 

105

810

 

106

1010

 

107

8378

 

108

181

 

109

2000

 

110

500

 

111

4756

 

Purchase-Payment

Purchase Number

Check Number

1

101

3

103

4

104

6

107

7

109

2

111

Service-Payment

Service Number

Check Number

3

100

3

102

1

105

2

105

7

105

8

106

4

108

9

110

  1. How much inventory did M & M buy from Sunny last month?
  2. Did any vendors sell M & M both inventory and services?  List all the vendors who sell M & M both inventory and services. Your answer should include Vendor Number and Name.
  3. To whom was check #111 sent? Your answer should include Vendor Number and Name.
  4. How much does M & M owe in accounts payable? Please show your work here.
  5. Draw a Data Model in Tables for the M & M Enterprises as the given system. Next, if you can improve their data structure for the future database system, please draw an improved Data Model for the M & M Enterprises.   

Reference no: EM133040791

Questions Cloud

Prepare extracts from burge ltd financial statements : Prepare extracts from Burge Ltd's financial statements for the year ended 30 April 2021 showing the effect of the lease
Phase of the five es : What phase of the five Es was most beneficial, and why? Were any of them not beneficial? If so, explain why.
Comment on the validity of reference checking : Many organizations will conduct a reference check before making an employment offer to the candidate. Typically, employers will ask the candidate for three name
Developing good communication skills : Developing good communication skills early in your career can allow you to set yourself apart from others in the organization as a leader.
Case-m and m enterprise system : Examine the tables below for M & M Enterprise system first and answer the following questions.
What internal and external resources may be utilised : What internal and external resources may be utilised in managing a conflict situation - Explain the key difference between qualitative and quantitative methods
Calculate the net present value of the two opportunities : Each of the opportunities shown below has a 15-year life. Robert uses a 12% discount rate. Calculate the net present value of the two opportunities
Review the marino enterprises customer complaints : Review the Marino Enterprises Customer Complaints Handling Procedure (provided as a handout) and complete the questions
What the current value of the ruble in terms of the peso : Mexican Peso is currently trading at .45 Turkish Lira. If triangular arbitrage holds, what the current value of the Ruble in terms of the Peso

Reviews

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd